On Tue, Aug 26, 2008 at 12:21 PM, Alvaro Herrera <[EMAIL PROTECTED]
> 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
>
