Re: count() in 9.2

Am 2012-10-17 21:03, schrieb Steve Horn:
> Thanks for the replies. I think I need to re-evaluate based on what
> you are
> saying. From earlier tests I was finding that Postgres was slow to
> count
> records with any WHERE clause. Maybe my perception was incorrect
> because my
> samples were not controlled.

I really think its the first step: Define a good set of data and a
couple of
typical queries using the data to compare systems. Also keep care to
bring up
valid indexing and -- I assuming you already did that -- a good layout
of data.
E.g. splitting tables if you have 0 either 1 conditions.

Cheers,
Frank