Re: About System Catalogs

From: Thomas Swan <tswan(at)idigx(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Francesco(dot)Borgoglio(at)cedacri(dot)it, pgsql-admin(at)postgresql(dot)org
Subject: Re: About System Catalogs
Date: 2004-10-23 02:50:43
Message-ID: 4179C703.9060603@idigx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Lane wrote:

>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.
>
>
>
Is REINDEX still going to be a necessity in the 8.0 release? I
remembered at there was a discussion on the mailing list about a fix or
need to fix VACUUM so that manually reindexing would not be necessary...

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2004-10-23 09:01:34 Re: About System Catalogs
Previous Message Gaetano Mendola 2004-10-22 20:50:34 Re: replication using WAL archives