Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 229F5475C22 for ; Wed, 15 Jan 2003 23:48:40 -0500 (EST) Received: from filer (12-235-198-106.client.attbi.com [12.235.198.106]) by postgresql.org (Postfix) with ESMTP id 7E0B1475BEC for ; Wed, 15 Jan 2003 23:48:39 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) (uid 1000) by filer with local; Wed, 15 Jan 2003 20:48:47 -0800 Date: Wed, 15 Jan 2003 20:48:47 -0800 From: Kevin Brown To: pgsql-performance@postgresql.org Subject: Re: 7.3.1 New install, large queries are slow Message-ID: <20030116044847.GA29781@filer> Mail-Followup-To: Kevin Brown , pgsql-performance@postgresql.org References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4BFD@pos_pdc.posportal.com> <11547.1042691700@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <11547.1042691700@sss.pgh.pa.us> User-Agent: Mutt/1.4i Organization: Frobozzco International X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/132 X-Sequence-Number: 779 Tom Lane wrote: > "Roman Fail" writes: > > Thanks to everyone for the quick replies! I'm sure that my lack of > > skill with SQL queries is the main problem. What's strange to me is > > how MSSQL takes my bad queries and makes them look good anyway. It > > must have a real smart planner. > > I think more likely the issue is that your use of JOIN syntax is forcing > Postgres into a bad plan. MSSQL probably doesn't assign any semantic > significance to the use of "a JOIN b" syntax as opposed to "FROM a, b" > syntax. Postgres does. Whether this is a bug or a feature depends on > your point of view --- but there are folks out there who find it to be > a life-saver. Since it *does* depend on one's point of view, would it be possible to have control over this implemented in a session-defined variable (with the default in the GUC, of course)? I wouldn't be surprised if a lot of people get bitten by this. -- Kevin Brown kevin@sysexperts.com