Horton

Re: [HACKERS] More detail on settings for pgavd?

Shridhar Daithankar <shridhar_daithankar@myrealbox.com>

View thread View on postgr.es
From: Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
To: Shridhar Daithankar <shridhar_daithankar@myrealbox.com>, "Matthew T. O'Connor" <matthew@zeut.net>
Cc: Josh Berkus <josh@agliodbs.com>, pgsql-performance@postgresql.org, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2003-11-20T15:07:13Z
Lists: pgsql-hackers, pgsql-performance

Attachments

On Thursday 20 November 2003 20:29, Shridhar Daithankar wrote:
> On Thursday 20 November 2003 20:00, Matthew T. O'Connor wrote:
> > Shridhar Daithankar wrote:
> > > I will submit a patch that would account deletes in analyze threshold.
> > > Since you want to delay the analyze, I would calculate analyze count as
> >
> > deletes are already accounted for in the analyze threshold.
>
> Yes. My bad. Deletes are not accounted in initializing analyze count but
> later they are used.
>
> > > I am still wary of inverting vacuum analyze frequency. You think it is
> > > better to set inverted default rather than documenting it?
> >
> > I think inverting the vacuum and analyze frequency is wrong.
>
> Me. Too. ATM all I can think of this patch attached. Josh, is it sufficient
> for you?..:-)

use this one. A warning added for too aggressive vacuumming. If it is OK by 
everybody, we can send it to patches list.

 Shridhar