Skip site navigation (1) Skip section navigation (2)

Re: Seeking insight from heavy lifters

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: John Wells <jb(at)sourceillustrated(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Seeking insight from heavy lifters
Date: 2003-09-29 15:46:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
What are the transfering from, exactly?


John Wells wrote:
> A manager friend of mine sent me the following concern.  He's preparing to
> shift to Postgresql from a proprietary DB and 4gl system:
> -----------
> To that end, I've also started studying up on Postgresql.  It seems to
> have all the necessary features for a transaction heavy DB.  The recent
> release is 7.3.  Of course, "the proof will be in the pudding."  We
> average 2.5 million transactions per day or 800 per second. 
> Unfortunately, we would have no way of testing that until we committed to
> getting the business logic moved over and had something to test it with. 
> This is a bit of a "catch 22" situation.  Just wished I knew of someone
> locally who was running Postgresql in such a heavy environment.  I'd love
> to find out how it performs for them. -----------
> While I have a lot of experience with PG, it's not really been in a heavy
> processing environment.  Could I get some input to send him from anyone
> out in the field using Postgres in a similar environment.
> If PG isn't the best option here, what is?
> Thanks very much for your input!
> John
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to


pgsql-general by date

Next:From: Achilleus MantziosDate: 2003-09-29 15:46:44
Subject: Conditional row grained + FK dependency oriented lazy replication
Previous:From: E. Zorn (RDG-rational) postsqlDate: 2003-09-29 15:34:22
Subject: Access - can't close Form

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group