OK. i see the link and change parameters in postgresql.conf i.e. When excecute a insert statement the memory up to 90% to use . it's normal ??????? Thank for yor help and sorry for my bad englis Regards Mario Soto > 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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
