Re: auto vacuuming
От | Joshua D. Drake |
---|---|
Тема | Re: auto vacuuming |
Дата | |
Msg-id | 442DF45E.4090409@commandprompt.com обсуждение исходный текст |
Ответ на | Re: auto vacuuming (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-admin |
> > The handwriting on the wall says that autovac will soon be on by > default, and perhaps become not-disablable some day after that > (like the second or third time we hear from someone who's lost > their data to XID wraparound after disabling it). > > So if there's a really convincing use-case for locking autovac out > of specific databases, we'd better hear it soon. Sure.. a database that has over 2500 connections per a directly connected Java rich client... I don't want autovac running on it from 8-8 but after that I will run my own vacuum process. I am smart enough to manage my data. If I want autovac I will turn it on. Joshua D. Drake > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/
В списке pgsql-admin по дате отправления: