pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feedVacuum Cost Documentation?
12+ messages / 6 participants
[nested] [flat]
* Vacuum Cost Documentation?
@ 2004-07-18 00:06 Matthew T. O'Connor <matthew@zeut.net>
0 siblings, 3 replies; 12+ messages in thread
From: Matthew T. O'Connor @ 2004-07-18 00:06 UTC (permalink / raw)
To: pgsql-hackers
Related to autovacuum work, I was looking into the new vacuum delay
functionality. I might be missing something, but I can't find anything
on it in the developer docs. Is that right?
Also, in the default postgresql.conf there is:
#vacuum_cost_naptime = 50 # 0-1000 milliseconds
however psql reports this value as 0. I assume this is just
postgresql.conf is just wrong. Can we fix this so it's consistent?
Thanks,
Matthew O'Connor
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-07-18 00:55 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Matthew T. O'Connor <matthew@zeut.net>
2 siblings, 0 replies; 12+ messages in thread
From: Bruce Momjian @ 2004-07-18 00:55 UTC (permalink / raw)
To: Matthew T. O'Connor <matthew@zeut.net>; +Cc: pgsql-hackers
Matthew T. O'Connor wrote:
> Related to autovacuum work, I was looking into the new vacuum delay
> functionality. I might be missing something, but I can't find anything
> on it in the developer docs. Is that right?
>
> Also, in the default postgresql.conf there is:
>
> #vacuum_cost_naptime = 50 # 0-1000 milliseconds
>
> however psql reports this value as 0. I assume this is just
> postgresql.conf is just wrong. Can we fix this so it's consistent?
I am not really fond of the term 'naptime'. Delay? Sleep?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-07-18 06:32 Tom Lane <tgl@sss.pgh.pa.us>
parent: Matthew T. O'Connor <matthew@zeut.net>
2 siblings, 1 reply; 12+ messages in thread
From: Tom Lane @ 2004-07-18 06:32 UTC (permalink / raw)
To: Matthew T. O'Connor <matthew@zeut.net>; +Cc: pgsql-hackers; Jan Wieck <JanWieck@Yahoo.com>
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> Related to autovacuum work, I was looking into the new vacuum delay
> functionality. I might be missing something, but I can't find anything
> on it in the developer docs. Is that right?
You are not missing anything. I already nagged Jan about this once...
Of course, this is hardly the only seriously-underdocumented thing in
CVS tip ;-). We'll need to make a major push on docs soon.
regards, tom lane
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-07-18 18:54 David Fetter <david@fetter.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 12+ messages in thread
From: David Fetter @ 2004-07-18 18:54 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-hackers; Jan Wieck <JanWieck@yahoo.com>
On Sun, Jul 18, 2004 at 02:32:10AM -0400, Tom Lane wrote:
> "Matthew T. O'Connor" <matthew@zeut.net> writes:
> > Related to autovacuum work, I was looking into the new vacuum
> > delay functionality. I might be missing something, but I can't
> > find anything on it in the developer docs. Is that right?
>
> You are not missing anything. I already nagged Jan about this
> once...
>
> Of course, this is hardly the only seriously-underdocumented thing
> in CVS tip ;-). We'll need to make a major push on docs soon.
Do tell. :)
Cheers,
D(oc writer ordinaire)
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-08-07 01:04 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Matthew T. O'Connor <matthew@zeut.net>
2 siblings, 1 reply; 12+ messages in thread
From: Bruce Momjian @ 2004-08-07 01:04 UTC (permalink / raw)
To: Matthew T. O'Connor <matthew@zeut.net>; +Cc: pgsql-hackers
Updated. Thanks.
---------------------------------------------------------------------------
Matthew T. O'Connor wrote:
> Related to autovacuum work, I was looking into the new vacuum delay
> functionality. I might be missing something, but I can't find anything
> on it in the developer docs. Is that right?
>
> Also, in the default postgresql.conf there is:
>
> #vacuum_cost_naptime = 50 # 0-1000 milliseconds
>
> however psql reports this value as 0. I assume this is just
> postgresql.conf is just wrong. Can we fix this so it's consistent?
>
> Thanks,
>
> Matthew O'Connor
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-08-07 03:08 Jan Wieck <JanWieck@Yahoo.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 2 replies; 12+ messages in thread
From: Jan Wieck @ 2004-08-07 03:08 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Matthew T. O'Connor <matthew@zeut.net>; pgsql-hackers
On 8/6/2004 9:04 PM, Bruce Momjian wrote:
> Updated. Thanks.
I thought we want to have the feature activated ... I reversed your
change and brought guc.c in sync instead.
Jan
>
> ---------------------------------------------------------------------------
>
> Matthew T. O'Connor wrote:
>> Related to autovacuum work, I was looking into the new vacuum delay
>> functionality. I might be missing something, but I can't find anything
>> on it in the developer docs. Is that right?
>>
>> Also, in the default postgresql.conf there is:
>>
>> #vacuum_cost_naptime = 50 # 0-1000 milliseconds
>>
>> however psql reports this value as 0. I assume this is just
>> postgresql.conf is just wrong. Can we fix this so it's consistent?
>>
>> Thanks,
>>
>> Matthew O'Connor
>>
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-08-07 03:32 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Jan Wieck <JanWieck@Yahoo.com>
1 sibling, 0 replies; 12+ messages in thread
From: Bruce Momjian @ 2004-08-07 03:32 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: Matthew T. O'Connor <matthew@zeut.net>; pgsql-hackers
Jan Wieck wrote:
> On 8/6/2004 9:04 PM, Bruce Momjian wrote:
>
> > Updated. Thanks.
>
> I thought we want to have the feature activated ... I reversed your
> change and brought guc.c in sync instead.
OK.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-08-07 03:34 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Jan Wieck <JanWieck@Yahoo.com>
1 sibling, 2 replies; 12+ messages in thread
From: Bruce Momjian @ 2004-08-07 03:34 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: Matthew T. O'Connor <matthew@zeut.net>; pgsql-hackers
Jan Wieck wrote:
> On 8/6/2004 9:04 PM, Bruce Momjian wrote:
>
> > Updated. Thanks.
>
> I thought we want to have the feature activated ... I reversed your
> change and brought guc.c in sync instead.
Uh, if the guy is doing a vacuum at night, does he want the delay?
Seems someone should have to enable the delay by default, or does your
setup recoginize when it is being run on a lightly loaded system?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-08-07 10:41 Gaetano Mendola <mendola@bigfoot.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 12+ messages in thread
From: Gaetano Mendola @ 2004-08-07 10:41 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>
Bruce Momjian wrote:
> Jan Wieck wrote:
>
>>On 8/6/2004 9:04 PM, Bruce Momjian wrote:
>>
>>
>>>Updated. Thanks.
>>
>>I thought we want to have the feature activated ... I reversed your
>>change and brought guc.c in sync instead.
>
>
> Uh, if the guy is doing a vacuum at night, does he want the delay?
> Seems someone should have to enable the delay by default, or does your
> setup recoginize when it is being run on a lightly loaded system?
TODO: make vacuum_cost_naptime aware of system load
:-)
Regards
Gaetano Mendola
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-08-07 13:34 Jan Wieck <JanWieck@Yahoo.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 1 reply; 12+ messages in thread
From: Jan Wieck @ 2004-08-07 13:34 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Matthew T. O'Connor <matthew@zeut.net>; pgsql-hackers
On 8/6/2004 11:34 PM, Bruce Momjian wrote:
> Jan Wieck wrote:
>> On 8/6/2004 9:04 PM, Bruce Momjian wrote:
>>
>> > Updated. Thanks.
>>
>> I thought we want to have the feature activated ... I reversed your
>> change and brought guc.c in sync instead.
>
> Uh, if the guy is doing a vacuum at night, does he want the delay?
> Seems someone should have to enable the delay by default, or does your
> setup recoginize when it is being run on a lightly loaded system?
>
>
Good that autovacuum didn't make it then, those people would have had a
big surprise :-)
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-08-07 16:59 Tom Lane <tgl@sss.pgh.pa.us>
parent: Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 0 replies; 12+ messages in thread
From: Tom Lane @ 2004-08-07 16:59 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; Matthew T. O'Connor <matthew@zeut.net>; pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:
> Good that autovacuum didn't make it then, those people would have had a
> big surprise :-)
If autovacuum had made it, would you expect someone to have enabled it
by default? Without advance discussion?
regards, tom lane
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Vacuum Cost Documentation?
@ 2004-08-07 17:39 Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 12+ messages in thread
From: Bruce Momjian @ 2004-08-07 17:39 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: Matthew T. O'Connor <matthew@zeut.net>; pgsql-hackers
Jan Wieck wrote:
> On 8/6/2004 11:34 PM, Bruce Momjian wrote:
>
> > Jan Wieck wrote:
> >> On 8/6/2004 9:04 PM, Bruce Momjian wrote:
> >>
> >> > Updated. Thanks.
> >>
> >> I thought we want to have the feature activated ... I reversed your
> >> change and brought guc.c in sync instead.
> >
> > Uh, if the guy is doing a vacuum at night, does he want the delay?
> > Seems someone should have to enable the delay by default, or does your
> > setup recoginize when it is being run on a lightly loaded system?
> >
> >
>
> Those people will instantly realize what is going on and either change
> the delay setting or start running vacuum at daytime too.
>
> What this buys us is that over time we will see less researches and
> articles telling people that you have to bring down a PostgreSQL DB
> frequently for vacuum maintenance because those "testers" run their fair
> comparisions with out of the box configuration settings.
I am not in favor of adding a delay in VACUUM unless people ask for it.
Imagine either night vacuum or a vacuum you run in your application
after you delete and just before you load a table. Neither want a
vacuum. I think people who want a delay will think to ask for it while
people who want a quick vacuum will just think that vacuum is slow.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2004-08-07 17:39 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-18 00:06 Vacuum Cost Documentation? Matthew T. O'Connor <matthew@zeut.net>
2004-07-18 00:55 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-07-18 06:32 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-07-18 18:54 ` David Fetter <david@fetter.org>
2004-08-07 01:04 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-08-07 03:08 ` Jan Wieck <JanWieck@Yahoo.com>
2004-08-07 03:32 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-08-07 03:34 ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-08-07 10:41 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-07 13:34 ` Jan Wieck <JanWieck@Yahoo.com>
2004-08-07 16:59 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-08-07 17:39 Re: Vacuum Cost Documentation? Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox