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: 200309291546.h8TFkec22849@candle.pha.pa.us (view raw or flat)
Thread:
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                        |  http://candle.pha.pa.us
  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

Responses

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-2014 The PostgreSQL Global Development Group