About System Catalogs

Поиск
Список
Период
Сортировка
От Francesco.Borgoglio@cedacri.it
Тема About System Catalogs
Дата
Msg-id OF90E61208.73686075-ONC1256F34.002FDB35-C1256F34.0031C592@cedacri.it
обсуждение исходный текст
Ответы Re: About System Catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: psql enhancement idea
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: NIC to NIC connection