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 93DB2D1C4C7 for ; Wed, 13 Aug 2003 15:50:00 +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 31224-07 for ; Wed, 13 Aug 2003 12:48:23 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 8E5D9D1C4BF for ; Wed, 13 Aug 2003 12:49:49 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 71CDA10259; Wed, 13 Aug 2003 11:42:15 -0400 (EDT) Received: from [10.0.2.6] (unknown [10.0.2.6]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 5F8D610248; Wed, 13 Aug 2003 11:42:13 -0400 (EDT) Subject: Re: How can I Improve performance in Solaris? From: Rod Taylor To: ingrid martinez Cc: Andrew Sullivan , Postgresql Performance In-Reply-To: <003e01c361ae$0cf914c0$8e64a8c0@ingridmartinez> References: <001f01c361a3$ae2c7ae0$8e64a8c0@ingridmartinez> <20030813143258.GC15743@libertyrms.info> <003e01c361ae$0cf914c0$8e64a8c0@ingridmartinez> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-W/s6Lp6iH1BGB0Ii6YHL" Message-Id: <1060789790.11688.21.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Wed, 13 Aug 2003 11:49:51 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/240 X-Sequence-Number: 3057 --=-W/s6Lp6iH1BGB0Ii6YHL Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2003-08-13 at 11:17, ingrid martinez wrote:=20 > The query that execute is only inserts, I use a batch of 300 and then do > commit. >=20 > insert into FLOWS values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Any foreign keys on this table? Triggers or Rules? What kind of hardware do you have? Anything else running on it? Could you provide the header information from top? Off the cuff, modify your postgresql.conf for the below and restart PostgreSQL. shared_buffers =3D 1000 # 2*max_connections, min 16 effective_cache_size =3D 4000 # default in 8k pages --=-W/s6Lp6iH1BGB0Ii6YHL Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/Ol4e6DETLow6vwwRAncYAJ4kl0nTEIuJUfboPG4JWe3VYWrIFACeMeZp Fc0qqCKlo87W51j1/t04zzE= =vY3Y -----END PGP SIGNATURE----- --=-W/s6Lp6iH1BGB0Ii6YHL--