>>>>> "J" == Jeff <threshar(at)torgo(dot)978(dot)org> 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
More than 2 procs is probably overkill.
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
In response to
pgsql-performance by date
|Next:||From: Vivek Khera||Date: 2003-09-12 19:06:59|
|Subject: Re: best arrangement of 3 disks for (insert) performance - Dell|
|Previous:||From: Vivek Khera||Date: 2003-09-12 19:03:07|
|Subject: Re: software vs hw hard on linux|