Andrew Dunstan wrote:
> I don't know if this has come up before exactly, but is it possible that
> we could get a performance gain from building multiple indexes from a
> single sequential pass over the base table?
It is already implemented in pg_bulkload
(http://pgbulkload.projects.postgresql.org/). Index tuples of multiple indexes
are spooled during the single sequential pass over the base table, and the
spooled index tuples are built up after all of the base table is scanned.
A proposal was submitted by Itagaki-san to integrate this feature into core.
see http://archives.postgresql.org/pgsql-hackers/2008-02/msg00811.php .
NTT Open Source Software Center
In response to
pgsql-hackers by date
|Next:||From: Stephen Frost||Date: 2008-04-01 13:29:03|
|Subject: Re: New boxes available for QA|
|Previous:||From: Stuart Brooks||Date: 2008-04-01 13:00:31|
|Subject: Re: [HACKERS] ANALYZE getting dead tuple count hopelessly