visibility map and reltuples

From: "Ned T(dot) Crigler" <crigler(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: visibility map and reltuples
Date: 2008-12-13 22:57:44
Message-ID: 20081213225744.GA2268@xavtug.hell-city.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

It appears that the visibility map patch is causing pg_class.reltuples to be
set improperly after a vacuum. For example, it is set to 0 if the map
indicated that no pages in the heap needed to be scanned.

Perhaps reltuples should not be updated unless every page was scanned during
the vacuum?

--
Ned T. Crigler

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bramandia Ramadhana 2008-12-13 23:03:19 Re: lifetime of TubleTableSlot* returned by ExecProcNode
Previous Message Markus Wanner 2008-12-13 22:26:54 Re: Sync Rep: First Thoughts on Code