Can you provide the output of explain analyze select count(id) from table; ? Uwe On Tuesday 25 March 2008, sathiya psql wrote: > On Tue, Mar 25, 2008 at 2:11 PM, CZUCZY Gergely > <gergely.czuczy@xxxxxxxxxxx> > > wrote: > > May I ask, do you have any indeces or a primary key on that table? > > yes, i have both the index and primary key on a column "id", > and am doing the > > SELECT count(id) from TABLE; > > this is taking 3 seconds -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
