I hope someone can help me with this vacuum problem. I can post more
info if needed.
Versions: Postgresql version 8.09 on FreeBSD 6.1
Situation: huge amounts of adds and deletes daily. Running daily vacuums
Problem: Vacuum times jump up from 45 minutes, or 1:30 minutes to 6+
hours overnight,
Steinar H. Gunderson wrote:
On Sat, May 05, 2007 at 03:57:25PM -0700, Yudhvir Singh Sidhu wrote:
Situation: huge amounts of adds and deletes daily. Running daily vacuums
If you have huge amounts of adds and deletes, you might want to vacuum more
often; optionally, look into
Steinar H. Gunderson wrote:
On Sat, May 05, 2007 at 09:52:56PM -0700, Yudhvir Singh Sidhu wrote:
Here is what I think the story is:
a. Large amounts of rows are added to and deleted from a table - daily.
With this much activity, the statistics get out of whack easily. That's
where AN
Jim Nasby wrote:
On May 5, 2007, at 5:57 PM, Yudhvir Singh Sidhu wrote:
Problem: Vacuum times jump up from 45 minutes, or 1:30 minutes to 6+
hours overnight, once every 1 to 3 months.
Solutions tried: db truncate - brings vacuum times down. Reindexing
brings vacuum times down.
Does it jump
Anyone know of a pg_stats howto? I'd appreciate any direction.
Yudhvir
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
Mark Kirkwood wrote:
Brandon Shalton wrote:
Hello all,
My hard disk is filling up in the /base directory to where it has
consumed all 200gig of that drive.
All the posts that i see keep saying move to a bigger drive, but at
some point a bigger drive would just get consumed.
How can i ke
