Re: vacuum all but system tables

Użytkownik Victor Yegorov napisał:
> * Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [19.03.2003 16:32]:
>
>>"Victor Yegorov" <viy(at)pirmabanka(dot)lv> writes:
>>
>>>I'd like to make a script to automatically vacuum all my DBs nightly. And
>>>I'd like to skip system tables, starting with pg_*.
>>
>>Um ... what in the world makes you think that's a good idea? System
>>tables need maintenance too.
>>
>> regards, tom lane
>
>
> Yes, of course they need.
>
> May be I'll put my question in a different manner:
>
> System tables are location-wide (I mean one set of tables for PostgreSQL
> location) or each database has it's own set of system tables?
>
> If second, I apologies for noising. If first, I'd like to have a separate
> script for them.

They are location-wide. What's wrong with default vacuuming all
databases at once nightly? Or maybe you better need to vacuume only
specific tables?

Regards,
Tomasz Myrta