Re: Performance Benchmarking for data-warehousing instance?

Поиск
Список
Период
Сортировка
От Huy Nguyen
Тема Re: Performance Benchmarking for data-warehousing instance?
Дата
Msg-id CALvPUDi3BhhU7RD+nPZ7eMjsO-G0zXt3kdjZLvLmRDJ4taqW=Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance Benchmarking for data-warehousing instance?  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Ответы Re: Performance Benchmarking for data-warehousing instance?
Re: Performance Benchmarking for data-warehousing instance?
Список pgsql-performance
Дерево обсуждения
Do you happen to have a link to it? Though I think different machine specs should yield different optimal postgresql.conf.

I'm looking for a hand-crafted set of data + queries tailored for OLAP so that I can try to manually tweak one config at a time and run against the benchmark.

I might considering creating one if no one has done it before.


On Sat, Feb 8, 2014 at 12:12 PM, Peter Geoghegan <peter.geoghegan86@gmail.com> wrote:
On Fri, Feb 7, 2014 at 7:36 PM, Huy Nguyen <huy@viki.com> wrote:
> I think pgtune is optimized more for OLTP application. Is there something
> similar to pgtune/pgbench for OLAP?

IIRC pgtune can be told to give out an OLAP-optimized postgresql.conf.
Maybe that's only recent versions?

--
Regards,
Peter Geoghegan

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Performance Benchmarking for data-warehousing instance?
Следующее
От: Wattana Hinchaisri
Дата:
Сообщение: Re: Performance Benchmarking for data-warehousing instance?