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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: auto vacuuming
Следующее
От: "Rajesh Kumar Mallah"
Дата:
Сообщение: Re: FW: Setting up of PITR system.