| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | Greg Stark <greg(dot)stark(at)enterprisedb(dot)com> |
| Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Ned T(dot) Crigler" <crigler(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: visibility map and reltuples |
| Date: | 2008-12-15 17:17:14 |
| Message-ID: | Pine.GSO.4.64.0812151207180.7153@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-12-15 17:24:32 | Re: Restore enforce_generic_type_consistency's breaks a farms |
| Previous Message | Joshua D. Drake | 2008-12-15 17:16:43 | Re: Block-level CRC checks |