| From: | Kai-Uwe Sattler <kus(at)tu-ilmenau(dot)de> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | index advisor |
| Date: | 2006-10-13 18:49:05 |
| Message-ID: | 2261C794-2772-42A9-88F5-F05926FD187B@tu-ilmenau.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Hi,
here is a patch implementing an index recommendation advisor for
7.4.13. It consists of extensions to the planner and the catalog as
well as a command line tool pg_advise in contrib. The index advisor
works as part of the EXPLAIN statement, i.e. by
set enable_indexadvisor=true;
explain select ...
you will find the recommended indexes in pg_indexadvisor afterwards.
Comments are welcome.
Best,
Kai
| Attachment | Content-Type | Size |
|---|---|---|
| indexadvisor.patch.gz | application/x-gzip | 18.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-10-13 18:55:42 | Re: ./configure argument checking |
| Previous Message | Jeff Davis | 2006-10-13 18:45:45 | Re: more anti-postgresql FUD |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2006-10-13 19:07:50 | Re: index advisor |
| Previous Message | Tom Lane | 2006-10-13 17:06:17 | Re: [HACKERS] array_accum aggregate |