| From: | Vivek Khera <khera(at)kcilink(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: software vs hw hard on linux |
| Date: | 2003-09-12 19:04:20 |
| Message-ID: | x78yotesln.fsf@yertle.int.kciLink.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>>>>> "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
performance.
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2003-09-12 19:06:59 | Re: best arrangement of 3 disks for (insert) performance - Dell |
| Previous Message | Vivek Khera | 2003-09-12 19:03:07 | Re: software vs hw hard on linux |