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 conside
On Fri, Feb 7, 2014 at 7:36 PM, Huy Nguyen 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 Geogheg
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
Hello list.
I know all the theory about vacuuming. I've got log tables that get
periodically pruned. The pruning is... quirky, though. It's not so
much deleting data, as summarizing many (thousands) of rows into one
single row. For that, a combination of deletes and updates are used.
In essence,
