I agree with that. I will go ahead and do a test implementation and share
the results with everyone.


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

Reply via email to