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@2ndQuadrant.com www.2ndQuadrant.us