Re: visibility map and reltuples - Mailing list pgsql-hackers

From Greg Smith
Subject Re: visibility map and reltuples
Date
Msg-id Pine.GSO.4.64.0812151207180.7153@westnet.com
Whole thread Raw
In response to Re: visibility map and reltuples  (Greg Stark <greg.stark@enterprisedb.com>)
List pgsql-hackers
On Mon, 15 Dec 2008, Greg Stark wrote:

> I wonder if we should switch to keeping reltuplesperpage instead.

It would be preferrable to not touch the user side of reltuples if 
possible, since it's the only instant way to get a good estimate of the 
number of rows in a table right now.  That's been a regular application 
technique for at least two years now, since 
http://www.varlena.com/GeneralBits/120.php popularized it.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Block-level CRC checks
Next
From: Tom Lane
Date:
Subject: Re: Restore enforce_generic_type_consistency's breaks a farms