Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group