>>>>> "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