Home > mailing lists

Re: postgresql is slow with larger table even it is in RAM - Mailing list pgsql-admin

From	sathiya psql
Subject	Re: postgresql is slow with larger table even it is in RAM
Date	March 25, 2008 08:48:40
Msg-id	f966c2ee0803250148i526f0669w97c583aa03dcf2f3@mail.gmail.com Whole thread Raw
In response to	postgresql is slow with larger table even it is in RAM ("sathiya psql" <sathiya.psql@gmail.com>)
Responses	Re: postgresql is slow with larger table even it is in RAM Re: postgresql is slow with larger table even it is in RAM
List	pgsql-admin

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

From: "Uwe C. Schroeder"
Date: 25 March 2008, 08:42:25
Subject: Re: postgresql is slow with larger table even it is in RAM

From: "sathiya psql"
Date: 25 March 2008, 08:50:35
Subject: Re: postgresql is slow with larger table even it is in RAM