Re: how to improve perf of 131MM row table?

Поиск
Список
Период
Сортировка
От Aaron Weber
Тема Re: how to improve perf of 131MM row table?
Дата
Msg-id 793dbf54-9aee-41c7-8fdb-613b800ba80d@email.android.com
обсуждение исходный текст
Ответ на Re: how to improve perf of 131MM row table?  (Shaun Thomas <sthomas@optionshouse.com>)
Список pgsql-performance


>I'm curious to see if Aaron can test his structure on 9.3 with the
>original data and WHERE clause and see if the planner still goes for
>the
>terrible plan. If it does, that would seem like an obvious planner
>tweak
>to me.

I will try to spin up a test 9.3 db and run the same queries to see if this is the case.   Least I can do in return for
thehelp.  



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

Предыдущее
От: Aaron Weber
Дата:
Сообщение: Re: how to improve perf of 131MM row table?
Следующее
От: Mark Kirkwood
Дата:
Сообщение: 60 core performance with 9.3