Re: Performance question 83 GB Table 150 million rows, distinct select

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Performance question 83 GB Table 150 million rows, distinct select
Дата
Msg-id 4EC49945.40408@agliodbs.com
обсуждение исходный текст
Ответ на Re: Performance question 83 GB Table 150 million rows, distinct select  (Tory M Blue <tmblue@gmail.com>)
Ответы Re: Performance question 83 GB Table 150 million rows, distinct select
Список pgsql-performance
Дерево обсуждения 
Tory,

A seq scan across 83GB in 4 minutes is pretty good.   That's over
300MB/s.  Even if you assume that 1/3 of the table was already cached,
that's still over 240mb/s.  Good disk array.

Either you need an index, or you need to not do this query at user
request time.  Or a LOT more RAM.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Performance question 83 GB Table 150 million rows, distinct select
Следующее
От: Tory M Blue
Дата:
Сообщение: Re: Performance question 83 GB Table 150 million rows, distinct select