On Mon, 14 Apr 2008 21:30:15 +0100
Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
> "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it> writes:
>
> > But why once you add the index and count distinct the performances
> > are still so far?
> > I'd say that counting in this case is not the hardest thing to do,
> > but rather the "distinct" part.
>
> Your tests have been a bit unfortunate in finding a few
> particularly soft bits in Postgres's underbelly.
While I digest the interesting things you wrote... are there any
comparative benchmark on count(*) with where clauses?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it