X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 110BED1D591 for ; Tue, 2 Dec 2003 21:58:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 06610-04 for ; Tue, 2 Dec 2003 17:57:44 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 2D7C2D1D58F for ; Tue, 2 Dec 2003 17:57:34 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id 507401E13; Tue, 2 Dec 2003 16:57:27 -0500 (EST) To: Josh Berkus Cc: Jeremiah Jahn , postgres performance Subject: Re: cross table indexes or something? From: Neil Conway In-Reply-To: <200312021127.52839.josh@agliodbs.com> (Josh Berkus's message of "Tue, 2 Dec 2003 11:27:52 -0800") References: <1069877651.22346.13.camel@bluejay.goodinassociates.com> <200312011147.51359.josh@agliodbs.com> <1070392092.22346.43.camel@bluejay.goodinassociates.com> <200312021127.52839.josh@agliodbs.com> Date: Tue, 02 Dec 2003 16:57:27 -0500 Message-ID: <87llpu288o.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/35 X-Sequence-Number: 4895 Josh Berkus writes: > 1) to keep it working, you will probably need to run ANALZYE more > often than you have been; I'm not sure why this would be the case -- can you elaborate? > 4) Currently, pg_dump does *not* back up statistics settings. Yes, it does. -Neil