X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 74F11475D0F for ; Sat, 26 Apr 2003 14:16:26 -0400 (EDT) Received: from flake.decibel.org (flake.decibel.org [66.93.216.19]) by postgresql.org (Postfix) with SMTP id 1EC5C475A80 for ; Sat, 26 Apr 2003 14:16:25 -0400 (EDT) Received: (qmail 78505 invoked by uid 1001); 26 Apr 2003 18:16:25 -0000 Date: Sat, 26 Apr 2003 13:16:25 -0500 From: "Jim C. Nasby" To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: Automatic analyze on select into Message-ID: <20030426131624.G66185@flake.decibel.org> Reply-To: jim@nasby.net References: <20030426101537.F66185@flake.decibel.org> <8335.1051373934@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <8335.1051373934@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Sat, Apr 26, 2003 at 12:18:54PM -0400 X-Operating-System: FreeBSD 4.8-RELEASE i386 X-Distributed: Join the Effort! http://www.distributed.net X-Spam-Status: No, hits=-38.6 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,SIGNATURE_SHORT_SPARSE, USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/218 X-Sequence-Number: 1724 On Sat, Apr 26, 2003 at 12:18:54PM -0400, Tom Lane wrote: > "Jim C. Nasby" writes: > > So, question is, would it make sense to automatically do an analyze > > after/during a SELECT INTO? > > I don't think so. Very often, temp tables are small and only used for > one or two operations anyway --- so the cost of an ANALYZE wouldn't be > repaid. If ANALYZE would be useful, the user can issue one. Ok, I'll add notes to appropriate pages in the documentation. BTW, do the notes entered into the interactive docs get rolled into the formal documentation at any point? -- Jim C. Nasby (aka Decibel!) jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"