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)
Список
Дерево обсуждения
can't stop autovacuum by HUP'ing the server Dave Cramer <pg@fastcrypt.com>
Re: can't stop autovacuum by HUP'ing the server Tom Lane <tgl@sss.pgh.pa.us>
Re: can't stop autovacuum by HUP'ing the server Dave Cramer <pg@fastcrypt.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 Dave Cramer <pg@fastcrypt.com>
Re: can't stop autovacuum by HUP'ing the server "Dave Cramer" <pg@fastcrypt.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 "Dave Cramer" <pg@fastcrypt.com>
Re: can't stop autovacuum by HUP'ing the server "Dave Cramer" <pg@fastcrypt.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 "Dave Cramer" <pg@fastcrypt.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 "Dave Cramer" <pg@fastcrypt.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 "Dave Cramer" <pg@fastcrypt.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 "Dave Cramer" <pg@fastcrypt.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 Tom Lane <tgl@sss.pgh.pa.us>
Re: can't stop autovacuum by HUP'ing the server "Dave Cramer" <pg@fastcrypt.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 Tom Lane <tgl@sss.pgh.pa.us>
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>
Re: can't stop autovacuum by HUP'ing the server "Dave Cramer" <pg@fastcrypt.com>
Re: can't stop autovacuum by HUP'ing the server Joshua Drake <jd@commandprompt.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 Tom Lane <tgl@sss.pgh.pa.us>
Re: can't stop autovacuum by HUP'ing the server "Dave Cramer" <pg@fastcrypt.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 "Dave Cramer" <pg@fastcrypt.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>
Re: can't stop autovacuum by HUP'ing the server Dave Cramer <pg@fastcrypt.com>
Re: can't stop autovacuum by HUP'ing the server Alvaro Herrera <alvherre@commandprompt.com>
On Tue, Aug 26, 2008 at 12:21 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote:
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 ?
Dave Cramer wrote:Hmm ... template0 is not supposed to need vacuuming, because it is
> Ok, back to why
>
> turns out template0 is the culprit, why is autovac not vacuuming this ?
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 по дате отправления
