Re: Do we need vacuuming when tables are regularly dropped?

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: Do we need vacuuming when tables are regularly dropped?
Дата
Msg-id 48E16B81.5080008@pinpointresearch.com
обсуждение исходный текст
Ответ на Re: Do we need vacuuming when tables are regularly dropped?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Do we need vacuuming when tables are regularly dropped?
Следующее
От: Reece Hart
Дата:
Сообщение: Re: Hex representation