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

Поиск
Список
Период
Сортировка
От sathiya psql
Тема Re: postgresql is slow with larger table even it is in RAM
Дата
Msg-id f966c2ee0803250142hae53ef4mfee4487d1fd052a2@mail.gmail.com
обсуждение исходный текст
Ответ на postgresql is slow with larger table even it is in RAM  ("sathiya psql" <sathiya.psql@gmail.com>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "sathiya psql"
Дата:
Сообщение: postgresql is slow with larger table even it is in RAM
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: postgresql is slow with larger table even it is in RAM