Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql is slow with larger table even it is in RAM - Mailing list pgsql-performance

From sathiya psql
Subject Re: postgresql is slow with larger table even it is in RAM
Date
Msg-id f966c2ee0803250142hae53ef4mfee4487d1fd052a2@mail.gmail.com
Whole thread Raw
In response to postgresql is slow with larger table even it is in RAM  ("sathiya psql" <sathiya.psql@gmail.com>)
List pgsql-performance
Tree view
On Tue, Mar 25, 2008 at 2:09 PM, jose javier parra sanchez <jojapasa@gmail.com> wrote:
It's been said zillions of times on the maillist. Using a select
count(*) in postgres is slow, and probably will be slow for a long
time. So that function is not a good way to measure perfomance.
Yes, but if the data is in HDD then we can say this...

but now the data is in RAM

pgsql-performance by date:

Previous
From: "sathiya psql"
Date:
Subject: postgresql is slow with larger table even it is in RAM
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: postgresql is slow with larger table even it is in RAM