Skip site navigation (1) Skip section navigation (2)

Re: software vs hw hard on linux

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 (view raw or flat)
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/

In response to

pgsql-performance by date

Next:From: Vivek KheraDate: 2003-09-12 19:06:59
Subject: Re: best arrangement of 3 disks for (insert) performance - Dell
Previous:From: Vivek KheraDate: 2003-09-12 19:03:07
Subject: Re: software vs hw hard on linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group