Postgres Pro
Downloads
Home   >   mailing lists

Re: Why not represent "never vacuumed" accurately wrt pg_class.relpages? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why not represent "never vacuumed" accurately wrt pg_class.relpages?
Date
Msg-id 4607.1544554795@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why not represent "never vacuumed" accurately wrtpg_class.relpages?  (Andres Freund <andres@anarazel.de>)
Responses Re: Why not represent "never vacuumed" accurately wrtpg_class.relpages?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
Andres Freund <andres@anarazel.de> writes:
> How's being unable to distinguish "never vacuumed" from "table is
> knowingly empty right now" not constrained by the representation?

Well, OK, it is constrained, but even if it weren't I'd be afraid to
assume a table is totally empty, even if it was so the last time
ANALYZE looked at it.  The plans you get from that are spectacularly
fragile.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Why not represent "never vacuumed" accurately wrtpg_class.relpages?
Next
From: Chapman Flack
Date:
Subject: Re: Record last password change