Re: [HACKERS] Metadata about relation creation & full scans. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Metadata about relation creation & full scans.
Date
Msg-id 25097.1490192054@sss.pgh.pa.us
Whole thread Raw
In response to [HACKERS] Metadata about relation creation & full scans.  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] Metadata about relation creation & full scans.  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> I propose that for each pg_class entry we start to keep the following
> additional metadata:
> - CATALOG_VERSION_NO at relation creation
> - PG_VERSION_NUM at relation creation
> - CATALOG_VERSION_NO at last full scan by vacuum
> - PG_VERSION_NUM at last full scan by vacuum

(1) It's very very hard for me to believe that we need *two* versions of
the version number.  Pick one.

(2) How you gonna update this in vacuum?  It cannot do a transactional
update.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix and simplify check forwhether we're running as Windows serv
Next
From: João Miguel Afonso
Date:
Subject: Re: [HACKERS] [GSoC] Personal presentation and request for clarification