Re: more than one index in a single heap pass? - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: more than one index in a single heap pass?
Date
Msg-id 4A60CDEC.7080506@enterprisedb.com
Whole thread Raw
In response to Re: more than one index in a single heap pass?  (decibel <decibel@decibel.org>)
List pgsql-hackers
decibel wrote:
> Here's an off-the-wall thought... since most of the CPU time is in the
> sort, what about allowing a backend to fork off dedicated sort
> processes? Aside from building multiple indexes at once, that
> functionality could also be useful in general queries.

Sure, that would be cool. And also a lot of work :-). The comparison
operators can be arbitrarily complex, potentially querying other tables
etc, so you would indeed need pretty much all the infrastrucutre you
need to solve the general case.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: commitfest application question
Next
From: "Kevin Grittner"
Date:
Subject: Re: Higher TOAST compression.