Re: pg_autovacuum UPDATE_INTERVAL cmd arg
От | Bruce Momjian |
---|---|
Тема | Re: pg_autovacuum UPDATE_INTERVAL cmd arg |
Дата | |
Msg-id | 200504190336.j3J3a3R28610@candle.pha.pa.us обсуждение исходный текст |
Ответ на | pg_autovacuum UPDATE_INTERVAL cmd arg (Thomas F.O'Connell <tfo@sitening.com>) |
Ответы |
Re: pg_autovacuum UPDATE_INTERVAL cmd arg
|
Список | pgsql-patches |
Also, since this is an additional feature, I assume it isn't for 8.0.X. --------------------------------------------------------------------------- Thomas F.O'Connell wrote: > The following patch should allow UPDATE_INTERVAL to be specified on the > command line. We find this useful because we frequently deal with > thousands of tables in an environment where neither the databases nor > the tables are updated frequently. This helps allow us to cut down on > the overhead of updating the list for every other primary loop of > pg_autovacuum. > > I chose -i as the command-line argument and documented it briefly in > the README. > > The patch was applied to the 7.4.7 version of pg_autovacuum in contrib. > > -tfo > > -- > Thomas F. O'Connell > Co-Founder, Information Architect > Sitening, LLC > http://www.sitening.com/ > 110 30th Avenue North, Suite 6 > Nashville, TN 37203-6320 > 615-260-0005 > [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- 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
В списке pgsql-patches по дате отправления: