| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Cc: | Bill Martin <bill(dot)martin(at)communote(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: [PERFORM] Planner selects different execution plans depending on limit |
| Date: | 2012-09-16 21:39:34 |
| Message-ID: | CAMkU=1xjEXM8PnZaS0bbKVYKhL-j7Ra_WK1hRk2Zv3zsa5xWwA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-performance |
On Thu, Sep 13, 2012 at 10:33 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bill Martin <bill(dot)martin(at)communote(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-09-16 22:16:55 | Re: [PERFORM] Planner selects different execution plans depending on limit |
| Previous Message | barrybrown | 2012-09-16 09:01:13 | BUG #7543: Invalid table alias: DELETE FROM table * |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-09-16 22:16:55 | Re: [PERFORM] Planner selects different execution plans depending on limit |
| Previous Message | Tom Lane | 2012-09-16 15:37:15 | Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate |