* Alvaro Herrera <[EMAIL PROTECTED]> wrote: > On Mon, Jul 04, 2005 at 02:17:47AM +0200, Enrico Weigelt wrote: > > * David Mitchell <[EMAIL PROTECTED]> wrote: > > > Perhaps if you are doing a lot of inserts and deletes, vacuuming every 6 > > > minutes would be closer to your mark. Try vacuuming every 15 minutes for > > > a start and see how that affects things (you will have to do a vacuum > > > full to get the tables back into shape after them slowing down as they > > > have). > > > > hmm. I've just done vacuum full at the moment on these tables, but it > > doesnt seem to change anything :( > > Maybe you need a REINDEX, if you have indexes on that table. Try that, > coupled with the frequent VACUUM suggestion.
Advertising
I've tried it, but it doesn't seem to help :( 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 8: explain analyze is your friend
