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

["sathiya psql" <sathiya.psql@xxxxxxxxx>]

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