From: Thomas Finneid <tfinneid@student.matnat.uio.no>
To: pgsql-performance@postgresql.org
Subject: importance of fast disks with pg
Date: Tue, 17 Jul 2007 23:44:14 +0200
Message-ID: <469D382E.6030603@ifi.uio.no> (raw)
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
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: tfinneid@student.matnat.uio.no
Subject: Re: importance of fast disks with pg
In-Reply-To: <469D382E.6030603@ifi.uio.no>
* 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