Re: Seeking insight from heavy lifters
От | Bruce Momjian |
---|---|
Тема | Re: Seeking insight from heavy lifters |
Дата | |
Msg-id | 200309291546.h8TFkec22849@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Seeking insight from heavy lifters ("John Wells" <jb@sourceillustrated.com>) |
Ответы |
Re: Seeking insight from heavy lifters
|
Список | 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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-general по дате отправления: