"Jonah H. Harris" <[EMAIL PROTECTED]> writes:
> Tom, Bruce, and others involved in this recurring TODO discussion…
> First, let me start by saying that I understand this has been discussed
> many times before; however, I’d like to see what the current state of
> affairs is regarding the possibility of using a unique index scan to
> speed up the COUNT aggregate.
It's not happening, because no one has come up with a workable proposal.
In particular, we're not willing to slow down every other operation in
order to make COUNT-*-with-no-WHERE-clause faster.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
