From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PERFORM] More detail on settings for pgavd? |
Date: | 2003-11-20 16:32:24 |
Message-ID: | 3FBCEC98.4080309@zeut.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
Shridhar Daithankar wrote:
>On Thursday 20 November 2003 20:00, Matthew T. O'Connor wrote:
>
>
>>Shridhar Daithankar wrote:
>>
>>
>>>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?..:-)
>
>
The patch just adds an example to the README, this looks ok to me.
>Matthew, I am confyused about one thing. Why would autovacuum count updates
>while checking for analyze threshold? Analyze does not change statistics
>right? ( w.r.t line 1072, pg_autovacuum.c). For updating statistics, only
>inserts+deletes should suffice, isn't it?
>
>
An update is the equivelant of an insert and a delete, so it counts
towards the analyze count as much as an insert.
>Other than that, I think autovacuum does everything it can.
>
>
It could be more customizable.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-11-20 16:35:26 | Re: [BUGS] 7.4: CHAR padding inconsistency |
Previous Message | Tom Lane | 2003-11-20 16:02:43 | Re: logical column position |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-11-20 17:18:30 | Re: [HACKERS] More detail on settings for pgavd? |
Previous Message | Shridhar Daithankar | 2003-11-20 15:07:13 | Re: [HACKERS] More detail on settings for pgavd? |