Announcement

Collapse
No announcement yet.

Tuning PostgreSQL for Mirth production use

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Tuning PostgreSQL for Mirth production use

    We recommend PostgreSQL for production use of Mirth (we use it on our appliances).

    Make sure you add the following lines to your postgre configuration file:

    autovacuum=on
    autovacuum_vacuum_threshold=1000

    This ensures that the database stays speedy, especially under large message volumes.
    Chris Lang

  • #2
    Re:Tuning PostgreSQL for Mirth production use

    Hi Chris,

    Can you please be more specific as to which file this information should be added to?

    Thanks!

    Kerry

    Comment


    • #3
      Re:Tuning PostgreSQL for Mirth production use

      It's in postgresql.conf in the data/ directory. There's a "AUTOVACUUM PARAMETERS" section - defaults are listed in there.

      mike

      Comment


      • #4
        Re:Tuning PostgreSQL for Mirth production use

        Sorry for jumping in late here.

        What about shared buffers, effective cache, max_fsm, etc ?

        autovacuum is but one setting.

        Comment


        • #5
          Re:Tuning PostgreSQL for Mirth production use

          The default values are generally OK for Mirth's purposes, but it depends a lot on your situation. Kernel parameters, system load, memory, etc., need to be looked at if you're tweaking these values.

          Chapter 17 of the PostgreSQL manual is all about this kind of stuff...

          mike

          Comment


          • #6
            Re:Tuning PostgreSQL for Mirth production use

            I do this for a living and I can guarantee orders of magnitude increases in throughput by tuning these values. Postgresql defaults to extremely conservative values.

            Dave

            Comment


            • #7
              Re:Tuning PostgreSQL for Mirth production use

              Hi Dave -

              Can you suggest some good starting values for these parameters? We would love to provide some better tuning suggestions.
              -Steve

              Comment


              • #8
                Re:Tuning PostgreSQL for Mirth production use

                Well, I'd be willing to trade this information for access to some paid support.

                Comment


                • #9
                  Re:Tuning PostgreSQL for Mirth production use

                  A nice overview and possibly some decent hints:
                  http://revsys.com/writings/postgresql-performance.html
                  and of course the pgsql-performance mailing lists....
                  http://archives.postgresql.org/pgsql-performance/

                  Post edited by: laidback_01, at: 05/05/2008 15:31

                  Comment


                  • #10
                    Re:Tuning PostgreSQL for Mirth production use

                    Hi Chris,
                    How can I buy suppot service from you?

                    Thanks
                    kew98

                    Comment


                    • #11
                      Re:Tuning PostgreSQL for Mirth production use

                      kew98 wrote:
                      Hi Chris,
                      How can I buy suppot service from you?

                      Thanks
                      kew98
                      I think this has been answered elsewhere, but if anybody is interested, I think you can buy support here. http://www.webreachinc.com/services/...upport-options
                      Oscar Gonzalez
                      : Home of the Mirth Healthcare Appliances.

                      Comment

                      Working...
                      X