Re: can't stop autovacuum by HUP'ing the server

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: can't stop autovacuum by HUP'ing the server
Дата
Msg-id 491f66a50808260926h1f70beb9q7249043373bc7f02@mail.gmail.com
обсуждение исходный текст
Ответ на Re: can't stop autovacuum by HUP'ing the server  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: can't stop autovacuum by HUP'ing the server  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Дерево обсуждения


On Tue, Aug 26, 2008 at 12:21 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote:
Dave Cramer wrote:

> Ok, back to why
>
> turns out template0 is the culprit, why is autovac not vacuuming this ?

Hmm ... template0 is not supposed to need vacuuming, because it is
frozen ... is it marked with datallowconn=false?

Yes

 select * from pg_database where datname='template0';
  datname  | datdba | encoding | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | dattablespace | datconfig |               datacl               
-----------+--------+----------+---------------+--------------+--------------+---------------+--------------+---------------+-----------+-------------------------------------
 template0 |     10 |        6 | t             | f            |           -1 |         11510 |    201850617 |          1663 |           | {=c/postgres,postgres=CTc/postgres}

So how to fix ?
 


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: can't stop autovacuum by HUP'ing the server
Следующее
От: Tom Lane
Дата:
Сообщение: Re: gsoc, oprrest function for text search take 2