Thread: About System Catalogs

About System Catalogs

From
Francesco.Borgoglio@cedacri.it
Date:

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.

Re: About System Catalogs

From
Tom Lane
Date:
Francesco.Borgoglio@cedacri.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

Re: About System Catalogs

From
Thomas Swan
Date:
Tom Lane wrote:
Francesco.Borgoglio@cedacri.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...

Re: About System Catalogs

From
Gaetano Mendola
Date:
Thomas Swan wrote:
> Tom Lane wrote:
>
>>Francesco.Borgoglio@cedacri.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...
>

This is already true for the 7.4, I don't remember that vacuum was improved
int that direction in the 8.0.



Regards
Gaetano Mendola