From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Axel Rau <Axel.Rau@Chaos1.DE>
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org, Abhijit Menon-Sen <ams@oryx.com>
Subject: Re: configuring new server / many slow disks?
Date: Fri, 09 Mar 2007 13:28:34 -0600
Message-ID: <1173468513.20651.298.camel@state.g2switchworks.com> (raw)
In-Reply-To: <834DBEC9-864E-49B0-BE65-E5A6F0378EA3@Chaos1.DE>
References: <AB0DB72D-0AC0-4ED5-B61E-E865703BBDB6@Chaos1.DE>
<45F1482F.8030901@archonet.com>
<834DBEC9-864E-49B0-BE65-E5A6F0378EA3@Chaos1.DE>
On Fri, 2007-03-09 at 11:39, Axel Rau wrote:
> Am 09.03.2007 um 12:42 schrieb Richard Huxton:
>
> > Axel Rau wrote:
> >> Hi performers,
> >> after following this list for a while, I try to configure a
> >> database server with a limited budget.
> >> Planned are 2 databases
> >> - archiveopteryx - http://www.archiveopteryx.org/sql-schema.html
> >> - ERDB - https://www.chaos1.de/svn-public/repos/network-tools/ERDB/
> >> trunk/database/ERD.pdf In peak times I expect something like
> >> - 50 inserts
> >> - 20 updates
> >> - 200 selects
> >> per second.
> >
> > Presumably with multiple clients, not just one extremely busy one?
> Multiple clients do mainly selects (the IMAP users), few mailservers
> are busy and do mainly inserts and updates.
> > How big do you expect the databases to get?
> Up to 1 TB. The 1st DB is an IMAP message store, which keeps Mime
> message parts as byteas in one table (bodyparts).
I'd benchmark it to make sure. 20 updates and 50 inserts per second on
simple tables with small amounts of data? No problem. Lots of big
bytea / blob data getting inserted and read back out? Not so sure.
Certainly your BBU RAID controller will help, and lots of slower hard
drives is generally far better than a few faster drives.
The only way to know is to make up a test and see how it performs.
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: smarlowe@g2switchworks.com, Axel.Rau@Chaos1.DE, dev@archonet.com, ams@oryx.com
Subject: Re: configuring new server / many slow disks?
In-Reply-To: <1173468513.20651.298.camel@state.g2switchworks.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