X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A5412D9117 for ; Thu, 22 Sep 2005 19:03:23 -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 29126-04 for ; Thu, 22 Sep 2005 22:03:19 +0000 (GMT) Received: from sccmmhc91.asp.att.net (sccmmhc91.asp.att.net [204.127.203.211]) by svr1.postgresql.org (Postfix) with ESMTP id 96CC5D90C1 for ; Thu, 22 Sep 2005 19:03:16 -0300 (ADT) Received: from juju.arbash-meinel.com ([12.214.18.81]) by sccmmhc91.asp.att.net (sccmmhc91) with ESMTP id <20050922220319m9100psr4se>; Thu, 22 Sep 2005 22:03:19 +0000 Received: by juju.arbash-meinel.com (Postfix, from userid 505) id 505CA55FF0; Thu, 22 Sep 2005 17:03:19 -0500 (CDT) Received: from [192.168.1.11] (liliana.arbash-meinel.com [192.168.1.11]) by juju.arbash-meinel.com (Postfix) with ESMTP id D462455FA4; Thu, 22 Sep 2005 17:03:16 -0500 (CDT) Message-ID: <43332A24.8000809@arbash-meinel.com> Date: Thu, 22 Sep 2005 17:03:16 -0500 From: John Arbash Meinel User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050727) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jean-Pierre Pelletier Cc: pgsql-performance@postgresql.org Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0 References: <433326A6.8010708@arbash-meinel.com> In-Reply-To: X-Enigmail-Version: 0.92.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig5B6AB798589056579FDCF7CE" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.045 required=5 tests=[AWL=-0.005, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/254 X-Sequence-Number: 14562 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig5B6AB798589056579FDCF7CE Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Jean-Pierre Pelletier wrote: > Here are the explain analyze: What is the explain analyze if you use "set enable_seqscan to off"? Also, can you post the output of: \d supplier \d price \d content Mostly I just want to see what the indexes are, in the case that you don't want to show us your schema. John =:-> --------------enig5B6AB798589056579FDCF7CE Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDMyokJdeBCYSNAAMRAhrEAJ49j8esl3O+garEmv6FzO0jHtipgQCgyzAs AJJTkr9d0RCD2VMy8B1/SqQ= =kd/z -----END PGP SIGNATURE----- --------------enig5B6AB798589056579FDCF7CE--