count(*) index

From: Tomka Gergely <tomka(at)zeus(dot)gau(dot)hu>
To: psql kezdő lista <pgsql-novice(at)postgresql(dot)org>
Subject: count(*) index
Date: 2005-01-07 18:22:56
Message-ID: Pine.LNX.4.58.0501071921050.3947@zeus.gau.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi!

Yes, i know, mvcc, and can't use indexes. And i know the workaround for
max() and min(). Is there some workaround for count()?

select count(*) from table where field=1;

and field has a nice index. And this is slooooow.

--
Tomka Gergely
Tudom, anyu. Sapka, sál, doksi.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Julie Cottin 2005-01-07 18:41:20 Driver Information Please
Previous Message sarlav kumar 2005-01-07 17:41:26 moving database to a new partition on disk