From: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
---|---|
To: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] More detail on settings for pgavd? |
Date: | 2003-11-20 15:07:13 |
Message-ID: | 200311202037.13091.shridhar_daithankar@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
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
Attachment | Content-Type | Size |
---|---|---|
difffile | text/x-diff | 2.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2003-11-20 15:17:00 | Re: 4 Clause license? |
Previous Message | Shridhar Daithankar | 2003-11-20 14:59:47 | Re: [HACKERS] More detail on settings for pgavd? |
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew T. O'Connor | 2003-11-20 16:32:24 | Re: [PERFORM] More detail on settings for pgavd? |
Previous Message | Shridhar Daithankar | 2003-11-20 14:59:47 | Re: [HACKERS] More detail on settings for pgavd? |