About System Catalogs

From: Francesco(dot)Borgoglio(at)cedacri(dot)it
To: pgsql-admin(at)postgresql(dot)org
Subject: About System Catalogs
Date: 2004-10-21 09:03:19
Message-ID: OF90E61208.73686075-ONC1256F34.002FDB35-C1256F34.0031C592@cedacri.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi gurus,
i have two questions for you.

1) I would like to know if the system catalogs tables are created
for each database of Postgresql instance or belong to a specific db,
such as template0 i suppose.

2) As i had a very large pg_largeogject, i deleted rows e now i have a
clean, small table.
The table is empty but its index pg_largeogject_loid_pn_index lasts
to retain a lot of bytes.
How can i do?
I have to drop and recreate the index?

Thank you very much.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2004-10-21 10:19:23 Re: NIC to NIC connection
Previous Message Gaetano Mendola 2004-10-21 08:07:33 Re: NIC to NIC connection