From: Dan Harris <fbsd@drivefaster.net>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: importance of fast disks with pg
Date: Tue, 17 Jul 2007 15:54:27 -0600
Message-ID: <469D3A93.8010701@drivefaster.net> (raw)
In-Reply-To: <469D382E.6030603@ifi.uio.no>
References: <469D382E.6030603@ifi.uio.no>
Thomas Finneid wrote:
> Hi
>
> During the somes I did I noticed that it does not necessarily seem to be
> true that one needs the fastest disks to have a pg system that is fast.
>
> It seems to me that its more important to:
> - choose the correct methods to use for the operation
> - tune the pg memory settings
> - tune/disable pg xlog/wal etc
>
> It also seems to me that fast disks are more important for db systems of
> the OLTP type applications with real concurrency of both readers and
> writes across many, possibly larger, tables etc.
>
> Are the above statements close to having any truth in them?
>
> regards
>
> thomas
I'd say that "it depends". We run an OLAP workload on 350+ gigs of database on
a system with 64GB of RAM. I can tell you for certain that fetching non-cached
data is very sensitive to disk throughput!
Different types of workloads will find different bottlenecks in the system..
-Dan
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: fbsd@drivefaster.net
Subject: Re: importance of fast disks with pg
In-Reply-To: <469D3A93.8010701@drivefaster.net>
* 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