Re: count() in 9.2

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Steve Horn <steve(at)stevehorn(dot)cc>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: count() in 9.2
Date: 2012-10-17 16:57:28
Message-ID: CA+U5nMJ6xOZ867CVNYs=1ruFrwJcAaZ3M8Q6N7p5jAioaDjyew@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 17 October 2012 17:22, Steve Horn <steve(at)stevehorn(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2012-10-17 17:48:26 Re: count() in 9.2
Previous Message Steve Horn 2012-10-17 16:22:21 Re: count() in 9.2