Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.2/8.9.1) with ESMTP id PAA27542 for ; Mon, 8 Mar 1999 15:23:13 -0500 (EST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id PAA08525; Mon, 8 Mar 1999 15:22:42 -0500 (EST) From: Bruce Momjian Message-Id: <199903082022.PAA08525@candle.pha.pa.us> Subject: Re: [SQL] 6.4.x vs. 6.5 oddity In-Reply-To: <19990308202253.21864.qmail@desertmoon.com> from "pierre@desertmoon.com" at "Mar 8, 1999 1:22:53 pm" To: pierre@desertmoon.com Date: Mon, 8 Mar 1999 15:22:42 -0500 (EST) Cc: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > > > > All, > > > I have started playing with 6.5 and duped my DB onto a > > > spare box. I grabbed one of the most intensive queries that > > > runs under the current system and ran it on 6.5. It took > > > FOREVER. I then ran explain on both 6.4 and 6.5 and here is > > > the output for both...can anyone explain what the issue is here? > > > Or is it just that 6.5 is still in development? > > > > > > (All tables are vacuumed) > > > > > > > Also, during the recent weeks, GEQO was being enabled for >= 6 tables. > > Try SET GEQO TO 'off'. The current CVS has the GEQO setting at 11. > > > > Ahh..tat fixed it. I already had the db vacuum analyze(d) and setting > GEQO to off gave me an EXPLAIN that was close to the one from 6.4 > here it is: Good. > > I do have one question...this particular query is taking about 20 seconds > to return...I've got postmaster setup with -i -B 512 -S -o -F, I had read > on this list that 6.5 was supposed to have a bit of a speed increase. Of > course this could be that I've only got 32MB in this test machine..? Should be much faster for joining many tables like this case. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026