Re: Performance Benchmarking for data-warehousing instance?

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(dot)geoghegan86(at)gmail(dot)com> wrote:

> On Fri, Feb 7, 2014 at 7:36 PM, Huy Nguyen <huy(at)viki(dot)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
>