Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 643B39F9CFF for ; Fri, 31 Aug 2007 15:04:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 41810-08 for ; Fri, 31 Aug 2007 15:04:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 6A2259F9CA1 for ; Fri, 31 Aug 2007 15:04:06 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 3A33431434; Fri, 31 Aug 2007 20:04:04 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.sql Subject: Re: Incomprehensible dogged sort in Merge Join Date: Fri, 31 Aug 2007 13:49:10 -0400 Organization: cbbrowne Computing Inc Lines: 32 Message-ID: <601wdjegrt.fsf@dba2.int.libertyrms.com> References: <46D82318.3070700@gmail.com> <877inb225q.fsf@oxford.xeocode.com> <46D82C11.5090506@gmail.com> <87y7frzq00.fsf@oxford.xeocode.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.4.20 (linux) Cancel-Lock: sha1:Ko5Ue6lJmQcWYeeYHSyVR9TMYiI= To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/268 X-Sequence-Number: 29206 stark@enterprisedb.com (Gregory Stark) writes: > "Aleksandr Vinokurov" writes: > >> Gregory Stark wrote: >>> >>> What version are you running with? >> >> 8.0.1, sorry for missing. > > There have been 12 bug-fix releases since then on the 8.0 branch including > updating timezones to reflect the new daylight saving time rules for North > America, various crashes, data corruption, and security bugs. There is no > reason not to upgrade to the current latest 8.0 branch release which is > 8.0.13. > > Separately, you may not want to upgrade to 8.2 now for operational > reasons but reporting "wishlist" bugs against a version that's two > major releases old is almost certainly going to be > pointless. Postgres is moving ahead so fast that the chances that > your wish is granted already in more recent releases are very high. Further, the chances of your wishes being granted on the 8.0 branch are somewhere between zero and none, and the changes since 8.0 are major enough that comparing against 8.0 for the purposes of discussion just generally isn't useful. -- (reverse (concatenate 'string "moc.enworbbc" "@" "enworbbc")) http://linuxfinances.info/info/oses.html Rule of Scarcity "If it's not allocated by a market, then it's more expensive than money." -- Mark Miller