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 OAA19303 for ; Mon, 8 Mar 1999 14:29:38 -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 OAA07835; Mon, 8 Mar 1999 14:29:30 -0500 (EST) From: Bruce Momjian Message-Id: <199903081929.OAA07835@candle.pha.pa.us> Subject: Re: [SQL] 6.4.x vs. 6.5 oddity In-Reply-To: <19990308192757.20501.qmail@desertmoon.com> from "pierre@desertmoon.com" at "Mar 8, 1999 12:27:57 pm" To: pierre@desertmoon.com Date: Mon, 8 Mar 1999 14:29:29 -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) VACUUM ANALYZE? -- 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