Tuning PostgreSQL for Mirth production use

[chrisl]

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.

[r_kerry]

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

[mnowlin]

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

[davec]

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.

[mnowlin]

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

[davec]

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

[stevier]

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

[davec]

Re:Tuning PostgreSQL for Mirth production use

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

[laidback_01]

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

[kew98]

Re:Tuning PostgreSQL for Mirth production use

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

Thanks
kew98

[oscarg]

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