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 15912D1C4D0 for ; Wed, 13 Aug 2003 16:17:14 +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 37951-02 for ; Wed, 13 Aug 2003 13:15:36 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id DE006D1C4BF for ; Wed, 13 Aug 2003 13:17:01 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19myJ4-0000m8-00 for ; Wed, 13 Aug 2003 12:17:02 -0400 Received: by dba2 (Postfix, from userid 1019) id 95586CF52; Wed, 13 Aug 2003 12:17:01 -0400 (EDT) Date: Wed, 13 Aug 2003 12:17:01 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: How can I Improve performance in Solaris? Message-ID: <20030813161701.GA599@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <001f01c361a3$ae2c7ae0$8e64a8c0@ingridmartinez> <20030813143258.GC15743@libertyrms.info> <003e01c361ae$0cf914c0$8e64a8c0@ingridmartinez> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <003e01c361ae$0cf914c0$8e64a8c0@ingridmartinez> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/241 X-Sequence-Number: 3058 On Wed, Aug 13, 2003 at 10:17:45AM -0500, ingrid martinez wrote: > The query that execute is only inserts, I use a batch of 300 and then do > commit. > > insert into FLOWS values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Are there any foreign keys, &c? > > and > > postgresql.conf looks like this [ . . .] The configuration is the default. You'll certainly want to increase the shared memory and fiddle with some of the other usual pieces. There is some discussion of the config file at . Unless the INSERTs are causing SELECTs, though, I can't see what exactly might be causing you so much difficulty. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110