public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: Jeff Janes <[email protected]>
Cc: [email protected]
Cc: Bill Martin <[email protected]>
Subject: Re: [PERFORM] Planner selects different execution plans depending on limit
Date: Sun, 16 Sep 2012 18:16:55 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMkU=1xjEXM8PnZaS0bbKVYKhL-j7Ra_WK1hRk2Zv3zsa5xWwA@mail.gmail.com>
References: <D48BF41C96B16442B542F5E25C259047011E80F02A@COM211.communardo.local>
<[email protected]>
<[email protected]>
<D48BF41C96B16442B542F5E25C259047011E811299@COM211.communardo.local>
<[email protected]>
<CAMkU=1xjEXM8PnZaS0bbKVYKhL-j7Ra_WK1hRk2Zv3zsa5xWwA@mail.gmail.com>
Jeff Janes <[email protected]> writes:
> On Thu, Sep 13, 2012 at 10:33 AM, Tom Lane <[email protected]> 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.)
regards, tom lane
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: [PERFORM] Planner selects different execution plans depending on limit
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox