| From: | Decibel! <decibel(at)decibel(dot)org> |
|---|---|
| To: | Greg Smith <gsmith(at)gregsmith(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: build multiple indexes in single table pass? |
| Date: | 2008-04-07 18:18:50 |
| Message-ID: | B0686358-9152-4AAE-81AA-0D0FFE269900@decibel.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Apr 1, 2008, at 10:03 PM, Greg Smith wrote:
> The idea we were bouncing around went a step past that and
> considered this: if you have good statistics on a table, and you
> have a sample set of queries you want to execute against it, how
> would you use that information to plan what indexes should be
> created? Needing to be able to create multiple indexes at once
> efficiently was an implementation detail to pull that off.
Someone at EnterpriseDB (Pavan?) did work on that. I don't know what
the status of that effort is.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Decibel! | 2008-04-07 18:22:36 | Re: New boxes available for QA |
| Previous Message | Josh Berkus | 2008-04-07 18:14:08 | Re: Feature freeze status |