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: Pine.LNX.4.58.0501071921050.3947@zeus.gau.hu (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group