Re: Duplicate tables information through metadata queries

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Duplicate tables information through metadata queries
Дата
Msg-id CAKFQuwavFiZLEr+eB3o5VZacFoQMRaGWgDzxjj2LFC7xNgO1Fg@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Duplicate tables information through metadata queries  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Список pgsql-jdbc
Дерево обсуждения
On Wednesday, September 8, 2021, ldh@laurent-hasson.com <ldh@laurent-hasson.com> wrote:


Vacuum Full doesn't rebuild indices??? I always thought it did as per the docs on https://www.postgresql.org/docs/13/routine-vacuuming.html.

Yeah, it has to rebuild the indexes since the physical locations of everything change during a vacuum full.  But doing that on the user table will not help - the oid stays the same and that is the only link (an indirect one at that) to the problem comment data.  Doing it on the catalog might help…never tried myself, vacuum full or a independent reindex. 

David J.

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Duplicate tables information through metadata queries
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Duplicate tables information through metadata queries