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

Поиск
Список
Период
Сортировка
От Samuel Gendler
Тема Re: Performance question 83 GB Table 150 million rows, distinct select
Дата
Msg-id CAEV0TzBxOdVjmwGx6rTsuQ7ekUxUo14Ki1aH9dLh_GPZHz4jUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance question 83 GB Table 150 million rows, distinct select  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Performance question 83 GB Table 150 million rows, distinct select  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Дерево обсуждения


On Wed, Nov 16, 2011 at 3:32 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:

If the OP's considering partitioning, they should really consider
upgrading to 9.1 which has much better performance of things like
aggregates against partition tables.


Could you elaborate on this a bit, or point me at some docs?  I manage a 600GB db which does almost nothing but aggregates on partitioned tables - the largest of which has approx 600 million rows across all partitions.  grouping in the aggregates tends to be on the partition column and rarely, if ever, would a group cross multiple partitions. We're on 9.0 and could definitely use some performance gains.


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

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