Re: About System Catalogs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Francesco(dot)Borgoglio(at)cedacri(dot)it
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: About System Catalogs
Date: 2004-10-21 23:55:01
Message-ID: 19253.1098402901@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Francesco(dot)Borgoglio(at)cedacri(dot)it writes:
> 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.

REINDEX should fix this.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Iain 2004-10-22 01:52:09 Re: replication using WAL archives
Previous Message Tom Lane 2004-10-21 22:50:06 Re: psql enhancement idea