>>>>> "J" == Jeff  <[EMAIL PROTECTED]> writes:

J> Due to various third party issues, and the fact PG rules, we're planning
J> on migrating our deplorable informix db to PG.  It is a rather large DB
J> with a rather high amount of activity (mostly updates).  So I'm going to

If at all possible, batch your updates within transactions containing
as many of those updates as you can.  You will get *much* better
performance.

More than 2 procs is probably overkill.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: [EMAIL PROTECTED]       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to