Re: Tuning PostgreSQL, pt 2

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Tuning PostgreSQL, pt 2
Date: 2003-07-30 14:41:52
Message-ID: 1059576111.7505.264.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 2003-07-29 at 15:38, Ron Johnson wrote:
> On Tue, 2003-07-29 at 15:09, scott.marlowe wrote:
> > On 29 Jul 2003, Ron Johnson wrote:
> >
> > > On Tue, 2003-07-29 at 14:00, scott.marlowe wrote:
> > > > On 29 Jul 2003, Ron Johnson wrote:
> > > >
> > > > > On Tue, 2003-07-29 at 11:18, scott.marlowe wrote:
> > > > > > On 29 Jul 2003, Ron Johnson wrote:
> > > > > >
> > > > > > > On Tue, 2003-07-29 at 10:14, Vivek Khera wrote:
> > > > > > > > >>>>> "GS" == Greg Stark <gsstark(at)mit(dot)edu> writes:
> > > > > > > >
> > > > > > > > GS> "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> [snip]
[snip]
> > I think most of them are running under TPF on a mainframe in a basement
> > somewhere, like for airline reservations. I've never worked on one, but
> > met one of the guys who runs one, and they use 12 mainframes for 6 live
> > machines and each live machine has a failover machine behind it in sysplex
> > mode. I kept thinking of the giant dinosaurs in Jurassic park...
>
> We have something similar running on Alphas and VMS; does about
> 8M Txn/day. Anyone who uses E-ZPass in the northeast eventually
> gets stuck in our systems.

Oh, forget to mention:
yes, they are in a 2-deep basement.

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-07-30 16:00:37 Getting Started Guide?
Previous Message Shridhar Daithankar 2003-07-30 13:56:48 Re: Why performance improvement on converting subselect to a function ?