Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 44C9E9FB443 for ; Mon, 9 Oct 2006 00:10:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 31878-03 for ; Mon, 9 Oct 2006 03:08:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 437DB9FB480 for ; Mon, 9 Oct 2006 00:04:06 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id C859530E18; Mon, 9 Oct 2006 05:04:04 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: Simple join optimized badly? Date: Mon, 09 Oct 2006 02:58:26 +0000 Organization: cbbrowne Computing Inc Lines: 14 Message-ID: <60hcye8ab1.fsf@dba2.int.libertyrms.com> References: <45274A77.7080005@modgraph-usa.com> <18722.1160236300@sss.pgh.pa.us> <5f820f750610071850o6ed0b19o162d65d1987b2a8c@mail.gmail.com> <200610081605.03501.josh@agliodbs.com> <12915.1160349397@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:TG9RRchGrhayW21zcelu3rH+LgM= To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/152 X-Sequence-Number: 21281 tgl@sss.pgh.pa.us (Tom Lane) writes: > Another thing we've been beat up about in the past is that loading a > pg_dump script doesn't ANALYZE the data afterward... Do I misrecall, or were there not plans (circa 7.4...) to for pg_dump to have an option to do an ANALYZE at the end? I seem to remember some dispute as to whether the default should be to include the ANALYZE, with an option to suppress it, or the opposite... -- (reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc")) http://www3.sympatico.ca/cbbrowne/wp.html "You can measure a programmer's perspective by noting his attitude on the continuing vitality of FORTRAN." -- Alan J. Perlis