On Thu, 17 Jun 2004, Patrick Hatcher wrote: > I have 6 million row table that I vacuum full analyze each night. The time > seems to be streching out further and further as I add more rows. I read
You could try to run normal (non full) vacuum every hour or so. If you do normal vacuum often enough you probably don't need to run vacuum full at all. -- /Dennis Björklund ---------------------------(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