I agree with that. I will go ahead and do a test implementation and share the results with everyone.
Thanks, Gokul. On 10/12/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > Andreas Joseph Krogh <[EMAIL PROTECTED]> writes: > > Will $SUBJECT make it possible for count(*) to use index? This is a much > > wanted feature. > > If you mean "count(*) will become instantaneous", no it won't. It would > get faster, but probably not by more than a factor of 10 or so, > corresponding to the size ratio between index and table. Remember that > the proposal is going to bloat indexes pretty badly: a simple index on > an int4 column will double in size, more or less. So that ratio will > be much less favorable than it is today. > > Personally I think the bloat problem will doom this entire approach. > The distributed costs of that will outweigh the speedups that can be > achieved for specific queries. The OP is free to try to prove this > fear wrong, but no amount of discussion will constitute such a proof; > only a testable implementation. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >
