pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedimportance of fast disks with pg
3+ messages / 3 participants
[nested] [flat]
* importance of fast disks with pg
@ 2007-07-17 21:44 Thomas Finneid <tfinneid@student.matnat.uio.no>
2007-07-17 21:54 ` Re: importance of fast disks with pg Dan Harris <fbsd@drivefaster.net>
2007-07-18 08:57 ` Re: importance of fast disks with pg Heikki Linnakangas <heikki@enterprisedb.com>
0 siblings, 2 replies; 3+ messages in thread
From: Thomas Finneid @ 2007-07-17 21:44 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: importance of fast disks with pg
2007-07-17 21:44 importance of fast disks with pg Thomas Finneid <tfinneid@student.matnat.uio.no>
@ 2007-07-17 21:54 ` Dan Harris <fbsd@drivefaster.net>
1 sibling, 0 replies; 3+ messages in thread
From: Dan Harris @ 2007-07-17 21:54 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: importance of fast disks with pg
2007-07-17 21:44 importance of fast disks with pg Thomas Finneid <tfinneid@student.matnat.uio.no>
@ 2007-07-18 08:57 ` Heikki Linnakangas <heikki@enterprisedb.com>
1 sibling, 0 replies; 3+ messages in thread
From: Heikki Linnakangas @ 2007-07-18 08:57 UTC (permalink / raw)
To: Thomas Finneid <tfinneid@student.matnat.uio.no>; +Cc: pgsql-performance
Thomas Finneid wrote:
> 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?
It depends.
The key to performance is to identify the bottleneck. If your CPU is
running at 50%, and spends 50% of the time waiting for I/O, a faster
disk will help. But only up to a point. After you add enough I/O
capability that the CPU is running at 100%, getting faster disks doesn't
help anymore. At that point you need to get more CPU power.
Here's the algorithm for increasing application throughput:
while throughput is not high enough
{
identify bottleneck
resolve bottleneck, by faster/more hardware, or by optimizing application
}
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-07-18 08:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-17 21:44 importance of fast disks with pg Thomas Finneid <tfinneid@student.matnat.uio.no>
2007-07-17 21:54 ` Dan Harris <fbsd@drivefaster.net>
2007-07-18 08:57 ` Heikki Linnakangas <heikki@enterprisedb.com>
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