* David Mitchell <[EMAIL PROTECTED]> wrote: > Did you vacuum full? > > When you do lots of inserts and deletes, dead tuples get left behind. > When you vacuum, postgres will reuse those dead tuples, but if you don't > vacuum for a long time these tuples will build up lots. Even when you > vacuum in this case, the dead tuples are still there, although they are > marked for reuse. Vacuuming full actually removes the dead tuples.
I'm doing a VACUUM ANALYZE every 6 hours. vacuum'ing manually doesnt seem to have any effect on that. cu -- --------------------------------------------------------------------- Enrico Weigelt == metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] --------------------------------------------------------------------- Realtime Forex/Stock Exchange trading powered by postgresSQL :)) http://www.fxignal.net/ --------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
