Skip site navigation (1) Skip section navigation (2)

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

From: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>
Subject: Re: postgresql is slow with larger table even it is in RAM
Date: 2008-03-25 17:55:28
Message-ID: 200803251055.28593.uwe@oss4u.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(dot)czuczy(at)harmless(dot)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

In response to

pgsql-admin by date

Next:From: Peter KoczanDate: 2008-03-25 17:59:17
Subject: Re: it refuses to go down...
Previous:From: Scott MarloweDate: 2008-03-25 15:29:36
Subject: Re: Tuning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group