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

[Luke Lonergan]

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" <[EMAIL PROTECTED]> wrote:

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