Performance Benchmarking for data-warehousing instance?

Поиск
Список
Период
Сортировка
От Huy Nguyen
Тема Performance Benchmarking for data-warehousing instance?
Дата
Msg-id CALvPUDgiGU5==ned9P6gJyNOSm4QHgUNFv7UT7xGoCjKfpeOzA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Performance Benchmarking for data-warehousing instance?  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Список pgsql-performance
Дерево обсуждения
We're using PostgreSQL to host our analytics (OLAP) database and trying to tune our configuration for better performance.

Is there any existing PG performance benchmarking tool set that tailors for OLAP purpose? Right now what we do is just go through the list of documentations 

I think pgtune is optimized more for OLTP application. Is there something similar to pgtune/pgbench for OLAP?

Thanks,
Huy

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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Bloated tables and why is vacuum full the only option
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Performance Benchmarking for data-warehousing instance?