From: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Scott Carey <scott@richrelevance.com>
Cc: jd@commandprompt.com, Merlin Moncure <mmoncure@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Jean-David Beyer <jeandavid8@verizon.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need help with 8.4 Performance Testing
Date: Thu, 11 Dec 2008 12:15:00 -0800
Message-ID: <494174C4.9040203@agliodbs.com> (raw)
In-Reply-To: <22285.1228862315@sss.pgh.pa.us>
References: <C5642B9E.F8A%scott@richrelevance.com>
<22285.1228862315@sss.pgh.pa.us>
Tom,
> Hmm ... I wonder whether this means that the current work on
> parallelizing I/O (the posix_fadvise patch in particular) is a dead
> end. Because what that is basically going to do is expend more CPU
> to improve I/O efficiency. If you believe this thesis then that's
> not the road we want to go down.
Nope. People who adminster small databases keep forgetting that there
is another class of users with multiple terabytes of data. Those users
aren't getting away from spinning disk anytime in the next 5 years.
Additionally, but making PostgreSQL work better with OS-based FS
optimization, we are well positioned to take advantage of any special
features which Linux, Solaris, BSD etc. add to utilize new hardware like
SSDs. posix_fadvise is a great example of this.
--Josh
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: josh@agliodbs.com, tgl@sss.pgh.pa.us, scott@richrelevance.com, mmoncure@gmail.com, scott.marlowe@gmail.com, jeandavid8@verizon.net
Subject: Re: Need help with 8.4 Performance Testing
In-Reply-To: <494174C4.9040203@agliodbs.com>
* 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