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

[sathiya psql]

On Tue, Mar 25, 2008 at 2:11 PM, CZUCZY Gergely <[EMAIL PROTECTED]>
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