Re: Should we increase the default vacuum_cost_limit?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Should we increase the default vacuum_cost_limit?
Дата
Msg-id
3811.1552169665@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Should we increase the default vacuum_cost_limit? David Rowley <david.rowley@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Should we increase the default vacuum_cost_limit? Peter Geoghegan <pg@bowt.ie>
Re: Should we increase the default vacuum_cost_limit? Joe Conway <mail@joeconway.com>
Re: Should we increase the default vacuum_cost_limit? David Rowley <david.rowley@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Laurenz Albe <laurenz.albe@cybertec.at>
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud <rjuju123@gmail.com>
Re: Should we increase the default vacuum_cost_limit? Robert Haas <robertmhaas@gmail.com>
Re: Should we increase the default vacuum_cost_limit? Laurenz Albe <laurenz.albe@cybertec.at>
Re: Should we increase the default vacuum_cost_limit? Peter Geoghegan <pg@bowt.ie>
Re: Should we increase the default vacuum_cost_limit? Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Robert Haas <robertmhaas@gmail.com>
Re: Should we increase the default vacuum_cost_limit? David Rowley <david.rowley@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Andres Freund <andres@anarazel.de>
Re: Should we increase the default vacuum_cost_limit? Jeremy Schneider <schnjere@amazon.com>
Re: Should we increase the default vacuum_cost_limit? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? David Rowley <david.rowley@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Jeff Janes <jeff.janes@gmail.com>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? David Rowley <david.rowley@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? David Rowley <david.rowley@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud <rjuju123@gmail.com>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud <rjuju123@gmail.com>
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud <rjuju123@gmail.com>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? David Rowley <david.rowley@2ndquadrant.com>
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud <rjuju123@gmail.com>
Re: [Suspect SPAM] Re: Should we increase the defaultvacuum_cost_limit? Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [Suspect SPAM] Re: Should we increase the defaultvacuum_cost_limit? Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud <rjuju123@gmail.com>
Re: Should we increase the default vacuum_cost_limit? Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should we increase the default vacuum_cost_limit? Tom Lane <tgl@sss.pgh.pa.us>
BTW ... I noticed while fooling with this that GUC's out-of-range
messages can be confusing:

regression=# set vacuum_cost_delay = '1s';
ERROR:  1000 is outside the valid range for parameter "vacuum_cost_delay" (0 .. 100)

One's immediate reaction to that is "I put in 1, not 1000".  I think
it'd be much clearer if we included the unit we'd converted to, thus:

ERROR:  1000 ms is outside the valid range for parameter "vacuum_cost_delay" (0 .. 100)

(Notice that this also implicitly tells what units the range limits
are being quoted in.  We could repeat the unit name in that part,
viz "(0 .. 100 ms)", but it seems unnecessary.)

A small problem with this idea is that GUC_UNIT_[X]BLOCK variables don't
really have a natural unit name.  If we follow the lead of pg_settings,
such errors would look something like

ERROR:  1000 8kB is outside the valid range for ...

I can't think of a better idea, though, and it'd still be clearer than
what happens now.

Barring objections I'll go make this happen.

			regards, tom lane

В списке pgsql-hackers по дате отправления
От: Paul Martinez
Дата:
От: Paul A Jungwirth
Дата:
FAQ