Skip site navigation (1) Skip section navigation (2)

Re: build multiple indexes in single table pass?

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: build multiple indexes in single table pass?
Date: 2008-04-01 12:47:31
Message-ID: 2e78013d0804010547q282e09ai43d729d62d06feca@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Apr 1, 2008 at 5:51 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>
>   From the "idle thoughts in the middle of the night" department:
>
>  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?

http://archives.postgresql.org/pgsql-performance/2008-02/msg00236.php

IMHO it should be possible to extend the grammar  to add
multiple indexes in one go. But the current index build itself looks
very tightly integrated with the heap scan. So it might be tricky to
separate out the scan and the index building activity.

Thanks,
Pavan


-- 
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

In response to

pgsql-hackers by date

Next:From: Aidan Van DykDate: 2008-04-01 12:49:54
Subject: Re: build multiple indexes in single table pass?
Previous:From: Andrew DunstanDate: 2008-04-01 12:21:46
Subject: build multiple indexes in single table pass?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group