Discussion:
About System Catalogs
(too old to reply)
F***@cedacri.it
2004-10-21 09:03:19 UTC
Permalink
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.
Tom Lane
2004-10-21 23:55:01 UTC
Permalink
Post by F***@cedacri.it
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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly
Thomas Swan
2004-10-23 02:50:43 UTC
Permalink
Post by Tom Lane
Post by F***@cedacri.it
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...
Gaetano Mendola
2004-10-23 09:01:34 UTC
Permalink
Post by Thomas Swan
Post by Tom Lane
Post by F***@cedacri.it
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

Loading...