Daniel Ferreira de Lima wrote:
> **Both with Linux Kernel 2 .4.37.9 and Postgresql 7.2** Wow. You really need to upgrade.Yes, but unfortunately, actually it's impossible and economically inviable...
Generally, getting good performance out of PostgreSQL 7.2 is also impossible and economically inviable. You can either put resources toward upgrading to a newer version, which will fix many of the performance issues here, or toward changes to the old version that are not guaranteed to actually improve anything.
That said, a look into the write-caching+BBU policy on your controller is worthwhile. If you're running this application successfully on some hardware but not others, that could be a source for the difference.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
