Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGtuK-0007PC-3R for pgsql-docs@postgresql.org; Wed, 26 Sep 2012 15:52:16 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGtuH-0003cH-TQ for pgsql-docs@postgresql.org; Wed, 26 Sep 2012 15:52:15 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1TGtuG-0001c2-0x; Wed, 26 Sep 2012 11:52:12 -0400 Date: Wed, 26 Sep 2012 11:52:12 -0400 From: Bruce Momjian To: Tom Lane Cc: Jeff Janes , pgsql-docs@postgresql.org, Bill Martin Subject: Re: [PERFORM] Planner selects different execution plans depending on limit Message-ID: <20120926155212.GC11785@momjian.us> References: <5051F227.7090600@krogh.cc> <26906.1347548059@sss.pgh.pa.us> <16905.1347557599@sss.pgh.pa.us> <28910.1347833815@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <28910.1347833815@sss.pgh.pa.us> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201209/27 X-Sequence-Number: 7479 On Sun, Sep 16, 2012 at 06:16:55PM -0400, Tom Lane wrote: > Jeff Janes writes: > > On Thu, Sep 13, 2012 at 10:33 AM, Tom Lane wrote: > >> Just pretend it's a table. > >> ALTER TABLE index_name ALTER COLUMN column_name SET STATISTICS ... > >> > >> You'll need to look at the index (eg with \d) to see what the name of > >> the desired column is, since index expressions have system-assigned > >> column names. > > > Is this documented anywhere? I couldn't find it. If not, which > > section would be the best one to add it to? > > It's not documented, mainly because it hasn't reached the level of being > a supported feature. I'd like to figure out how to get pg_dump to dump > such settings before we call it supported. (The stumbling block is > exactly that index column names aren't set in stone, so it's not clear > that the ALTER command would do the right thing on dump-and-reload.) Is this TODO? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +