From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | John Wells <jb(at)sourceillustrated(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres vs. Progress performance |
Date: | 2003-09-29 18:19:47 |
Message-ID: | 1064859587.2406.491.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 2003-09-29 at 12:43, John Wells wrote:
> We
> average 2.5 million transactions per day or 800 per second.
800*60*60*24 = 69 million per day... are you doing 2.5 million with
burst of up to 800 per second?
we average around 190 tps, though the high burst i see in the last few
seconds is only 270... about 1/3 of those are inserts and/or updates.
the box its running on is a dual pentium 1.3ghz with 1GB of RAM. it's
not optimal hardware either (only 2 disks for starters), but it runs
pretty solidly and the server its on doesn't seem too taxed..
i feel pretty confident that postgresql can handle your workload without
much trouble, you just need to give it enough hardware.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2003-09-29 18:20:36 | Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) |
Previous Message | James Moe | 2003-09-29 18:10:05 | Re: numeric rounding |