Re: build multiple indexes in single table pass? - Mailing list pgsql-hackers

From Decibel!
Subject Re: build multiple indexes in single table pass?
Date
Msg-id B0686358-9152-4AAE-81AA-0D0FFE269900@decibel.org
Whole thread Raw
In response to Re: build multiple indexes in single table pass?  (Greg Smith <gsmith@gregsmith.com>)
List 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@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Feature freeze status
Next
From: Decibel!
Date:
Subject: Re: New boxes available for QA