Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jeff.janes@gmail.com>) id 1TDMZ0-0003R3-9P
	for pgsql-docs@postgresql.org; Sun, 16 Sep 2012 21:39:38 +0000
Received: from mail-iy0-f174.google.com ([209.85.210.174])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jeff.janes@gmail.com>) id 1TDMYy-0001N6-3c
	for pgsql-docs@postgresql.org; Sun, 16 Sep 2012 21:39:37 +0000
Received: by iahk25 with SMTP id k25so4889769iah.19
	for <pgsql-docs@postgresql.org>; Sun, 16 Sep 2012 14:39:34 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	bh=hjB8cx1FesvtT0k/PPVnuQcgkXLfFSofXLFM5ixb91I=;
	b=uPCmAXw34bOknZSGyFdKIrYwrOHFcj4kcYlI8pCSVT5zWkROacoAhidrJMewyXBpUv
	xZblRJqfe6HHwPUm7/3xyrlPiV1TyWo0xHB3Lr0EjvzjFz09KdmvwIT23zdPkUqqyMfd
	Ef+iT/Kq1A5zofaFVZsHq8QXB1nhi/4kPRhmVDuiYF2WPzvcCE+tD3SL/F1UCun0n1z4
	RkijoimuJIHOLBRvE3IiKw5QWMqwCnAUn2JK3UCbaCgZGZsgZm5k1b5TD2G0psDdEhiy
	N/he6A7OfA2vQb7f40k9qX6l2IyoOrdDksNUp2UR9A6lcdNQjoAC4ttnbSv3g2owZ2Sw
	GrcA==
MIME-Version: 1.0
Received: by 10.50.219.229 with SMTP id pr5mr5024263igc.59.1347831574595; Sun,
	16 Sep 2012 14:39:34 -0700 (PDT)
Received: by 10.42.255.136 with HTTP; Sun, 16 Sep 2012 14:39:34 -0700 (PDT)
In-Reply-To: <16905.1347557599@sss.pgh.pa.us>
References: 
 <D48BF41C96B16442B542F5E25C259047011E80F02A@COM211.communardo.local>
	<5051F227.7090600@krogh.cc> <26906.1347548059@sss.pgh.pa.us>
	<D48BF41C96B16442B542F5E25C259047011E811299@COM211.communardo.local>
	<16905.1347557599@sss.pgh.pa.us>
Date: Sun, 16 Sep 2012 14:39:34 -0700
Message-ID: 
 <CAMkU=1xjEXM8PnZaS0bbKVYKhL-j7Ra_WK1hRk2Zv3zsa5xWwA@mail.gmail.com>
Subject: Re: [PERFORM] Planner selects different execution plans depending on
	limit
From: Jeff Janes <jeff.janes@gmail.com>
To: pgsql-docs@postgresql.org
Cc: Bill Martin <bill.martin@communote.com>, Tom Lane <tgl@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201209/15
X-Sequence-Number: 7467

On Thu, Sep 13, 2012 at 10:33 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Bill Martin <bill.martin@communote.com> writes:
>
>> How can I adjust the statistics target of the index?
>
> 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?

Cheers,

Jeff