Postgres Pro
Downloads
Home   >   mailing lists

Re: can't stop autovacuum by HUP'ing the server - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: can't stop autovacuum by HUP'ing the server
Date
Msg-id 20080826162130.GI4920@alvh.no-ip.org
Whole thread Raw
In response to Re: can't stop autovacuum by HUP'ing the server  ("Dave Cramer" <pg@fastcrypt.com>)
Responses 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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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?

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

pgsql-hackers by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: can't stop autovacuum by HUP'ing the server
Next
From: "Dave Cramer"
Date:
Subject: Re: can't stop autovacuum by HUP'ing the server