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

From Steve Crawford
Subject Re: Do we need vacuuming when tables are regularly dropped?
Date
Msg-id 48E16B81.5080008@pinpointresearch.com
Whole thread Raw
In response to Re: Do we need vacuuming when tables are regularly dropped?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom Lane wrote:
> Steve Crawford <scrawford@pinpointresearch.com> writes:
>
>> postgres@[local]=> CLUSTER pg_class USING pg_class_oid_index ;
>> ERROR:  "pg_class" is a system catalog
>>
>
> I think the DB is probably protecting you from yourself here ;-).

And elsewhere. :)

I wasn't advocating for a change of behavior, just the addition of
"Clustering is not permitted on system tables." to the documentation of
the CLUSTER command.

Cheers,
Steve




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Do we need vacuuming when tables are regularly dropped?
Next
From: Reece Hart
Date:
Subject: Re: Hex representation