On Wed, 26 May 2004, Mario Soto wrote:
> tha machine is a Pentium IV 2,6 GHZ AND 1 GB IN RAM with lINUX RH 9.0.
>
> BUT THE PERFORMANCE IT´S VERY SLOW
How often do you run VACUUM ANALYZE? You might want to do that every night
or every hour (depending on how much updates you have).
Some of your config values could and should be tuned, read something like
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
Still, if it's very slow it's probably not just a little tweaking of these
variables that solves everything.
If that is the case you need to find a slow query, run EXPLAIN ANALYZE on
it and try to figure out why it is slow. There is a list to help with
performance issues called pgsql-performance that you might want to post to
(and read its archive).
But before anything else, make sure you run VACUUM ANALYZE regulary.
--
/Dennis Björklund