| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Bruno Lavoie" <bruno(dot)lavoie(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Questions regarding indexes |
| Date: | 2009-01-16 20:23:35 |
| Message-ID: | 11281.1232137415@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> The order doesn't matter. Analyze doesn't know anything about the
> indexes, it knows about the fields / tables. I.e. if you run analyze,
> then create the index, you get the same basic result as if you create
> the index then run analyze.
There is an exception to that statement, which is indexes on functions
(expressions). Existence of such an index prompts analyze to gather
stats about the indexed expression. For plain column indexes, you're
right, it doesn't matter.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Long | 2009-01-16 20:27:12 | Re: Query sometimes takes down server |
| Previous Message | Scott Marlowe | 2009-01-16 20:23:27 | Re: Query sometimes takes down server |