Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Bruno Wolff IIIDate: 2004-10-21 10:19:23
Subject: Re: NIC to NIC connection
Previous:From: Gaetano MendolaDate: 2004-10-21 08:07:33
Subject: Re: NIC to NIC connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group