On Jan 5, 2008 5:38 AM, Ed L. <[EMAIL PROTECTED]> wrote:
> We need some advice on how to handle some large table autovacuum
> issues. One of our 8.1.2 autovacuums is launching a DB-wide
> vacuum on our 270GB database to prevent xid wrap-around, but is
> getting hung-up and/or bogged down for hour
"Ed L." <[EMAIL PROTECTED]> wrote:
>
> On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
> > On Jan 4, 2008 6:38 PM, Ed L. <[EMAIL PROTECTED]> wrote:
> > > We need some advice on how to handle some large table
> > > autovacuum issues. One of our 8.1.2
> >
> > First of all, update your 8.1 in
On Jan 4, 2008 7:29 PM, Ed L. <[EMAIL PROTECTED]> wrote:
> On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
> >
> > Have you tried adjusting the
> >
> > #vacuum_cost_delay = 0 # 0-1000 milliseconds
> > #vacuum_cost_page_hit = 1 # 0-1 credits
> > #vacuum_cos
Ed L. wrote:
On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
On Jan 4, 2008 6:38 PM, Ed L. <[EMAIL PROTECTED]> wrote:
We need some advice on how to handle some large table
autovacuum issues. One of our 8.1.2
First of all, update your 8.1 install to 8.1.10. Failing to
keep up with bug
On Jan 4, 2008 7:41 PM, Ed L. <[EMAIL PROTECTED]> wrote:
> On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
> > On Jan 4, 2008 6:38 PM, Ed L. <[EMAIL PROTECTED]> wrote:
> > > We need some advice on how to handle some large table
> > > autovacuum issues. One of our 8.1.2
> >
> > First of all
On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
> On Jan 4, 2008 6:38 PM, Ed L. <[EMAIL PROTECTED]> wrote:
> > We need some advice on how to handle some large table
> > autovacuum issues. One of our 8.1.2
>
> First of all, update your 8.1 install to 8.1.10. Failing to
> keep up with bug f
On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
>
> Have you tried adjusting the
>
> #vacuum_cost_delay = 0 # 0-1000 milliseconds
> #vacuum_cost_page_hit = 1 # 0-1 credits
> #vacuum_cost_page_miss = 10 # 0-1 credits
> #vacuum_cost_page_dirt
On Jan 4, 2008 6:38 PM, Ed L. <[EMAIL PROTECTED]> wrote:
> We need some advice on how to handle some large table autovacuum
> issues. One of our 8.1.2
First of all, update your 8.1 install to 8.1.10. Failing to keep up
with bug fixes is negligent. who knows, you might be getting bitten
by a bug
We need some advice on how to handle some large table autovacuum
issues. One of our 8.1.2 autovacuums is launching a DB-wide
vacuum on our 270GB database to prevent xid wrap-around, but is
getting hung-up and/or bogged down for hours on a 40gb table and
taking the server performance down with
