Re: postgresql is slow with larger table even it is in RAM

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@harmless.hu>
>
> 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