Re: Simple thing to make pg_autovacuum more useful

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Simple thing to make pg_autovacuum more useful
Дата
Msg-id 20080117140638.6c7c3d25@commandprompt.com
обсуждение исходный текст
Ответ на Re: Simple thing to make pg_autovacuum more useful  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Simple thing to make pg_autovacuum more useful  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 17 Jan 2008 16:54:47 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> > - -1? That way by default it will use the settings in
> > postgresql.conf?
> 
> Surely we're not going to force initdb for that.

I didn't realize it would take that so sure lets do it for 8.4.

> 
> > Secondly can we set the default for freeze_min_age to 100mil (I
> > think that is the default in the docs) and freeize_max_age to the
> > default 200000000 .
> 
> This is an outright bad idea, because those defaults aren't
> hard-wired. Why would you not use -1 if you want a default value?

There are two things here. One having a default value 8.2 currently
doesn't (8.3 I don't know). Two what the default value should be. I
will happily defer to you on that determination.

Sincerely,

Joshua D. Drake
- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHj9FuATb/zqfZUUQRAlt3AKCWo+v26U2iyD2wpoRAQxFlmHwfWwCePyYf
qQcaopPJ1ocYe+kcKIwEWYM=
=AtNk
-----END PGP SIGNATURE-----

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Renaming a constraint's index
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Simple thing to make pg_autovacuum more useful