Re: Much Ado About COUNT(*) - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Much Ado About COUNT(*)
Date
Msg-id 41E649A1.3030009@familyhealth.com.au
Whole thread Raw
In response to Re: Much Ado About COUNT(*)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> The fundamental problem is that you can't do it without adding at least
> 16 bytes, probably 20, to the size of an index tuple header.  That would
> double the physical size of an index on a simple column (eg an integer
> or timestamp).  The extra I/O costs and extra maintenance costs are
> unattractive to say the least.  And it takes away some of the
> justification for the whole thing, which is that reading an index is
> much cheaper than reading the main table.  That's only true if the index
> is much smaller than the main table ...

Well, the trick would be to have it specified per-index, then it's up to 
the user whether it's faster or not...


pgsql-hackers by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: looking for rh9 rpms for pgadmin v 1.2
Next
From: Dave Cramer
Date:
Subject: Re: looking for rh9 rpms for pgadmin v 1.2