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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
