Re: Performance Benchmarking for data-warehousing instance?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
On Fri, Feb 7, 2014 at 7:36 PM, Huy Nguyen <huy@xxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux