Re: Do we need vacuuming when tables are regularly dropped? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Do we need vacuuming when tables are regularly dropped?
Date
Msg-id 25195.1222728353@sss.pgh.pa.us
Whole thread Raw
In response to Re: Do we need vacuuming when tables are regularly dropped?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Do we need vacuuming when tables are regularly dropped?  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-admin
"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> Also, there was a time when you couldn't do vacuum full on system
> tables do to locking issues, and had to take the db down to single
> user mode to do so.

There was a short period when *concurrent* vacuum fulls on just the
wrong combinations of system catalogs could deadlock (because they both
needed to look up stuff in the other one).  AFAIK we fixed that.  It's
never been the case that it didn't work at all.

            regards, tom lane

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: PID file
Next
From: Steve Crawford
Date:
Subject: Re: Do we need vacuuming when tables are regularly dropped?