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

[Luke Lonergan <llonergan@xxxxxxxxxxxxx>]

Title: Re: 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@xxxxxxxxx> wrote:

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