count(*) index - Mailing list pgsql-novice

From Tomka Gergely
Subject count(*) index
Date
Msg-id Pine.LNX.4.58.0501071921050.3947@zeus.gau.hu
Whole thread Raw
Responses Re: count(*) index
List 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.

pgsql-novice by date:

Previous
From: sarlav kumar
Date:
Subject: moving database to a new partition on disk
Next
From: "Julie Cottin"
Date:
Subject: Driver Information Please