| From: | matt <matt(at)ymogen(dot)net> |
|---|---|
| To: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
| Cc: | PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Hardware recommendations to scale to silly load |
| Date: | 2003-08-28 08:17:20 |
| Message-ID: | 1062058639.15800.247.camel@gibraltar.mattclark.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
> Are you *sure* about that???? 3K updates/inserts per second xlates
> to 10,800,000 per hour. That, my friend, is a WHOLE HECK OF A LOT!
Yup, I know!
> During the 1 hour surge, will SELECTs at 10 minutes after the
> hour depend on INSERTs at 5 minutes after the hour?
Yes, they do. It's a payments system, so things like account balances
and purchase histories have to be updated in real time.
> Only one hour out of 168????? May I ask what kind of app it is?
Online voting for an unnamed TV show...
> > If the best price/performance option is a second hand 32-cpu Alpha
> > running VMS I'd be happy to go that way ;-)
>
> I'd love to work on a GS320! You may even pick one up for a million
> or 2. The license costs for VMS & Rdb would eat you, though.
You'd be amazed how little they do go for actually :-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeroen T. Vermeulen | 2003-08-28 08:19:57 | Re: 2-phase commit |
| Previous Message | Shridhar Daithankar | 2003-08-28 07:07:53 | Re: Replication Ideas |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-08-28 09:02:36 | Re: Hardware recommendations to scale to silly load |
| Previous Message | Dennis Björklund | 2003-08-28 08:11:02 | Re: The results of my PostgreSQL/filesystem performance |