From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: Performance Benchmarking for data-warehousing instance?
Date: Sun, 09 Feb 2014 16:42:37 +0100
Message-ID: <52F7A1ED.1050701@fuzzy.cz> (raw)
In-Reply-To: <CALvPUDi3BhhU7RD+nPZ7eMjsO-G0zXt3kdjZLvLmRDJ4taqW=Q@mail.gmail.com>
References: <CALvPUDgiGU5==ned9P6gJyNOSm4QHgUNFv7UT7xGoCjKfpeOzA@mail.gmail.com>
<CAEYLb_Wdihcpt3FNTK-JqoJxtRFkiEfETpJ2bHEAgrL-CX4HGA@mail.gmail.com>
<CALvPUDi3BhhU7RD+nPZ7eMjsO-G0zXt3kdjZLvLmRDJ4taqW=Q@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi,
On 8.2.2014 07:41, Huy Nguyen wrote:
> Do you happen to have a link to it? Though I think different machine
> specs should yield different optimal postgresql.conf.
An optimal configuration is not just about machine specs, it's about the
workload and application configuration too. So there's no benchmark that
would give you the best config for your application.
> 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 think using pgtune is the best starting point you can get, and you may
tweak it based on your actual workload. If you can prepare a sample of
the workload (i.e. a representative amount of data) and run a set of
actual queries (generated by the application), that'd be an excellent
situation.
> I might considering creating one if no one has done it before.
So how exactly is that going to work? There's an benchmark for this,
called TPC-H [1], but again - this is just a model of how a DWH/DSS
application may look like.
I've spent a lot of time working with it a while ago (see [2]), and IMHO
the values recommended by pgtune are quite fine.
[1] http://www.tpc.org/tpch/default.asp
[2] http://www.fuzzy.cz/en/articles/dss-tpc-h-benchmark-with-postgresql/
regards
Tomas
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz
Subject: Re: Performance Benchmarking for data-warehousing instance?
In-Reply-To: <52F7A1ED.1050701@fuzzy.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox