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

From: Luke Lonergan <llonergan(at)greenplum(dot)com>
To: Peter Koczan <pjkoczan(at)gmail(dot)com>, sathiya psql <sathiya(dot)psql(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgresql is slow with larger table even it is in RAM
Date: 2008-03-27 17:32:44
Message-ID: C411284C.58842%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

So your table is about 80 MB in size, or perhaps 120 MB if it fits in
shared_buffers. You can check it using ³SELECT
pg_size_pretty(pg_relation_size(Œmytable¹))²

- Luke

On 3/26/08 4:48 PM, "Peter Koczan" <pjkoczan(at)gmail(dot)com> wrote:

> FWIW, I did a select count(*) on a table with just over 300000 rows,
> and it only took 0.28 sec.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2008-03-27 17:36:55 Re: "Slow" query or just "Bad hardware"?
Previous Message Bill Moran 2008-03-27 17:07:44 Re: "Slow" query or just "Bad hardware"?