Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 17F7D9FB988 for ; Wed, 11 Jul 2007 15:34:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 27603-06 for ; Wed, 11 Jul 2007 15:34:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from brmea-mail-3.sun.com (brmea-mail-3.Sun.COM [192.18.98.34]) by postgresql.org (Postfix) with ESMTP id 9AF4E9FB929 for ; Wed, 11 Jul 2007 15:34:17 -0300 (ADT) Received: from fe-amer-05.sun.com ([192.18.108.179]) by brmea-mail-3.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l6BIYEfo005280 for ; Wed, 11 Jul 2007 18:34:14 GMT Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JL100K0127I0Y00@mail-amer.sun.com> (original mail from J.K.Shah@Sun.COM) for pgsql-performance@postgresql.org; Wed, 11 Jul 2007 12:34:14 -0600 (MDT) Received: from [129.148.9.17] by mail-amer.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JL1003O1291LEO2@mail-amer.sun.com>; Wed, 11 Jul 2007 12:34:14 -0600 (MDT) Date: Wed, 11 Jul 2007 14:34:13 -0400 From: "Jignesh K. Shah" Subject: Re: PostgreSQL publishes first real benchmark In-reply-to: <27436.1184173639@sss.pgh.pa.us> To: Tom Lane Cc: Heikki Linnakangas , pgsql-performance@postgresql.org Message-id: <469522A5.1070409@sun.com> Organization: Sun Microsystems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT References: <46925AD9.9020208@sun.com> <4694FE64.8070407@enterprisedb.com> <4695063D.9040108@sun.com> <27436.1184173639@sss.pgh.pa.us> User-Agent: Thunderbird 1.5.0.8 (X11/20061110) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/110 X-Sequence-Number: 25794 Can you list others that seemed out of place? Thanks. Regards, Jignesh Tom Lane wrote: > "Jignesh K. Shah" writes: > >> Heikki Linnakangas wrote: >> >>> May I ask you why you set max_prepared_transactions to 450, while >>> you're apparently not using prepared transactions, according to this >>> quote: >>> > > >> Yep.. one of the things that we didn't revert back and got strayed out >> there. >> > > There were quite a few settings in that list that looked like random > experimentation rather than recommendable good practice to me. > > regards, tom lane >