Skip site navigation (1)
Skip section navigation (2)
Title: Re: [PERFORM] postgresql is slow with larger table even it is in RAM 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:
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 27 Mar 2008 10:32:44 -0700
Title: Re: [PERFORM] postgresql is slow with larger table even it is in RAM 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.
- References:
- Re: postgresql is slow with larger table even it is in RAM
- From: Peter Koczan
- Re: postgresql is slow with larger table even it is in RAM
- Prev by Date: Re: "Slow" query or just "Bad hardware"?
- Next by Date: Re: "Slow" query or just "Bad hardware"?
- Previous by thread: Re: postgresql is slow with larger table even it is in RAM
- Next by thread: what is the maximum number of rows in a table in postgresql 8.1
- Indexes: