X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6BD25D1B4F1 for ; Fri, 12 Sep 2003 19:05:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 36433-06 for ; Fri, 12 Sep 2003 16:04:31 -0300 (ADT) Received: from lorax.kciLink.com (lorax.kciLink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id 2D404D1B4E8 for ; Fri, 12 Sep 2003 16:04:30 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id A0CEF3E9D for ; Fri, 12 Sep 2003 15:04:31 -0400 (EDT) Received: from lorax.kciLink.com ([127.0.0.1]) by localhost (lorax.kciLink.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 38441-02-4 for ; Fri, 12 Sep 2003 15:04:21 -0400 (EDT) Received: from lorax.kciLink.com (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id 24DE83E8B for ; Fri, 12 Sep 2003 15:04:21 -0400 (EDT) Received: (from news@localhost) by lorax.kciLink.com (8.12.8p1/8.12.8/Submit) id h8CJ4LSV028045 for pgsql-performance@postgresql.org; Fri, 12 Sep 2003 15:04:21 -0400 (EDT) To: pgsql-performance@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.performance Subject: Re: software vs hw hard on linux Date: Fri, 12 Sep 2003 15:04:20 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 17 Message-ID: References: NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kciLink.com 1063393461 1178 216.194.193.105 (12 Sep 2003 19:04:21 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Fri, 12 Sep 2003 19:04:21 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Portable Code, berkeley-unix) Cancel-Lock: sha1:pTToLlSgg9Zz9vFbpDg+4RMTMmI= X-Virus-Scanned: by amavisd-new at kciLink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/208 X-Sequence-Number: 3574 >>>>> "J" == Jeff 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@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/