Re: Duplicate tables information through metadata queries - Mailing list pgsql-jdbc

From David G. Johnston
Subject Re: Duplicate tables information through metadata queries
Date
Msg-id CAKFQuwavFiZLEr+eB3o5VZacFoQMRaGWgDzxjj2LFC7xNgO1Fg@mail.gmail.com
Whole thread Raw
In response to RE: Duplicate tables information through metadata queries  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Duplicate tables information through metadata queries
Next
From: "David G. Johnston"
Date:
Subject: Duplicate tables information through metadata queries