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 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