From: Scott Marlowe <smarlowe@qwest.net>
To: Milosz Miecznik <michoo.inne@mga.com.pl>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL Performance
Date: Wed, 09 Jun 2004 10:38:19 -0600
Message-ID: <1086799099.23855.17.camel@localhost.localdomain> (raw)
In-Reply-To: <003401c44e2e$db738660$9801a8c0@MGA.local>
References: <003401c44e2e$db738660$9801a8c0@MGA.local>
On Wed, 2004-06-09 at 08:34, Milosz Miecznik wrote:
> Hi!
>
> I have very important question about performance of PostgreSQL Database. How
> it will work with:
> - about 3000000 insert operation per day,
> - about 1000000 selects per day,
> - about 100 still connected users?
> What hardware platform shall I use for such big database (RAM, No. of CPUs,
> Hard discs capasity...?)
> What operating system shall I use? (I think about RedHat 8.x)
In acceptance testing on a dual 2.8 GHz P4 with 2 gigs ram and a pair of
UWSCSI drives running under an LSI/MegaRAID320 controller, with
pg_autovacuum running in the background, I was able to handle 10,000,000
transactions in 12 hours. That was with 250 simo connections running
40,000 transactions each.
Now, how big are your inserts? If they're reasonable small, like
financial info, then you can easily handle 3M inserts a day. If they're
really complex and have lots of constraints or FKs to deal with, then
maybe not. But a Dual P4 with 2 gigs ram and a pair of mirrored hard
drives is kinda an entry level db server nowadays. A machine with more
disk bandwidth could probably handle quite a bit more.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@qwest.net, michoo.inne@mga.com.pl
Subject: Re: PostgreSQL Performance
In-Reply-To: <1086799099.23855.17.camel@localhost.localdomain>
References: <003401c44e2e$db738660$9801a8c0@MGA.local> <1086799099.23855.17.camel@localhost.localdomain>
* 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