X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 67B8F5E3F15 for ; Wed, 1 Sep 2004 06:15:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76279-05 for ; Wed, 1 Sep 2004 09:15:20 +0000 (GMT) Received: from smtp-bal.opennet.it (noder32-48.opennet.it [212.110.32.48]) by svr1.postgresql.org (Postfix) with SMTP id 0AB845E4713 for ; Wed, 1 Sep 2004 06:15:13 -0300 (ADT) Received: (qmail 573 invoked from network); 1 Sep 2004 09:14:13 -0000 Received: from unknown (HELO comai04) (212.110.56.34) by 0 with SMTP; 1 Sep 2004 09:14:13 -0000 Message-ID: <065501c49004$b2864770$0501a8c0@comai04> From: "Stefano Bonnin" To: "Josh Berkus" Cc: References: <007c01c48c03$269b50c0$0501a8c0@comai04> <200408271014.29619.josh@agliodbs.com> <006a01c48e9b$964fe530$0501a8c0@comai04> <200408300954.51268.josh@agliodbs.com> Subject: Re: Query performance issue with 8.0.0beta1 Date: Wed, 1 Sep 2004 11:18:52 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/5 X-Sequence-Number: 8133 Server HP: Intel(R) Pentium(R) 4 CPU 2.26GHz RAM 1GB OS: RedHat 8 And the disk: kernel: megaide: driver version 05.04f (Date: Nov 11, 2002; 18:15 EST) kernel: megaide: bios version 02.06.07221605 kernel: megaide: LD 0 RAID1 status=ONLINE sectors=156297343 capacity=76317 MB drives=2 kernel: scsi0 : LSI Logic MegaIDE RAID BIOS Version 2.6.07221605, 8 targs 1 chans 8 luns kernel: Vendor: LSILOGIC Model: LD 0 IDERAID Rev: kernel: Type: Direct-Access ANSI SCSI revision: 02 Thanks. RedS ----- Original Message ----- From: "Josh Berkus" To: "Stefano Bonnin" Sent: Monday, August 30, 2004 6:54 PM Subject: Re: [PERFORM] Query performance issue with 8.0.0beta1 > Stefano, > > > This is my postgres.conf, I have changed only the work_mem and > > shared_buffers parameters. > > And not very much, I see. > > > >DID you > > > configure it for the 8.0 database? > > > > What does it mean? Is in 8.0 some important NEW configation parameter ? > > Well, there are but they shouldn't affect your case. However, there are a > lot of other settings that need to be adjusted. Please post your hardware > plaform information: OS, CPU, RAM, and disk setup. > > -- > Josh Berkus > Aglio Database Solutions > San Francisco >