About System Catalogs - Mailing list pgsql-admin

From Francesco.Borgoglio@cedacri.it
Subject About System Catalogs
Date
Msg-id OF90E61208.73686075-ONC1256F34.002FDB35-C1256F34.0031C592@cedacri.it
Whole thread Raw
Responses Re: About System Catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql enhancement idea
Next
From: Gaetano Mendola
Date:
Subject: Re: NIC to NIC connection