On 17 October 2012 17:22, Steve Horn <steve@stevehorn.cc> wrote:
> Yeah I should have mentioned...adding a where clause is always my use case
> when using count().
>
> So to clarify my question: does anyone have any experience with count()
> (with a WHERE clause) in Postgres 9.2?
If the WHERE clause looks only at columns in one index it might be
faster, otherwise same.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services