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 BD6A152AA6 for ; Mon, 18 Jul 2005 02:56:42 -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 96888-02 for ; Mon, 18 Jul 2005 05:56:34 +0000 (GMT) Received: from rambo.iniquinet.com (rambo.iniquinet.com [69.39.89.10]) by svr1.postgresql.org (Postfix) with ESMTP id 8F69552A73 for ; Mon, 18 Jul 2005 02:56:33 -0300 (ADT) Received: (qmail 12607 invoked by uid 1010); 18 Jul 2005 01:56:33 -0400 Received: from Robert_Creager@LogicalChaos.org by rambo.iniquinet.com by uid 1002 with qmail-scanner-1.20 (clamscan: 0.70. spamassassin: 3.0.3. Clear:RC:0(63.147.78.131):SA:0(?/?):. Processed in 1.2516 secs); 18 Jul 2005 05:56:33 -0000 Received: from unknown (HELO thunder.logicalchaos.org) (perl?test@logicalchaos.org@63.147.78.131) by rambo.iniquinet.com with AES256-SHA encrypted SMTP; 18 Jul 2005 01:56:31 -0400 Received: from logicalchaos.org (thunder.logicalchaos.org [192.168.0.250]) by thunder.logicalchaos.org (Postfix) with ESMTP id 7DBBD72328; Sun, 17 Jul 2005 23:56:30 -0600 (MDT) Date: Sun, 17 Jul 2005 23:56:30 -0600 From: Robert Creager To: Tom Lane Cc: PGPerformance , Andy Hewitt Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS Message-ID: <20050717235630.26a7c979@thunder.logicalchaos.org> In-Reply-To: <24520.1121659853@sss.pgh.pa.us> References: <20050717213416.59dcb52e@thunder.logicalchaos.org> <24520.1121659853@sss.pgh.pa.us> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed-Claws 1.0.3 (GTK+ 1.2.10; i586-mandrake-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Signature_Sun__17_Jul_2005_23_56_30_-0600_qOYAQc/dgQEn9yoa"; protocol="application/pgp-signature"; micalg=pgp-sha1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/253 X-Sequence-Number: 13494 --Signature_Sun__17_Jul_2005_23_56_30_-0600_qOYAQc/dgQEn9yoa Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable When grilled further on (Mon, 18 Jul 2005 00:10:53 -0400), Tom Lane confessed: > The context swap problem was no worse in 8.0 than in prior versions, > so that hardly seems like a good explanation. Have you tried reverting > to the cron-based vacuuming method you used in 7.4? >=20 I've "vacuum_cost_delay =3D 10" in the conf file for 803. hit, miss, dirty= and limit are 1, 10, 20 and 200 respectively. Could that be contributing to the problem? I'll know more in an hour or so with 741 running and cron vac and= the same load. Cheers, Rob --=20 23:53:53 up 4 days, 3:28, 6 users, load average: 0.11, 0.13, 0.11 Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004 --Signature_Sun__17_Jul_2005_23_56_30_-0600_qOYAQc/dgQEn9yoa Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iEYEARECAAYFAkLbRI4ACgkQLQ/DKuwDYzko9QCeLnwlPcHVNLWZITxl/CXdIZQm pyAAn2pAlqiWxpXlb/B4A+O1mG8HnVOf =TwF/ -----END PGP SIGNATURE----- --Signature_Sun__17_Jul_2005_23_56_30_-0600_qOYAQc/dgQEn9yoa--