Multiple index builds on same table - in one sweep?
От
Chris Ruprecht
Тема
Multiple index builds on same table - in one sweep?
Дата
Msg-id
DD8709CB-474F-4002-B555-1ED974371364@ruprecht.org
Список
Дерево обсуждения
Multiple index builds on same table - in one sweep? Chris Ruprecht <chris@ruprecht.org>
Re: Multiple index builds on same table - in one sweep? Tom Lane <tgl@sss.pgh.pa.us>
Re: Multiple index builds on same table - in one sweep? Chris Ruprecht <chris@ruprecht.org>
Re: Multiple index builds on same table - in one sweep? Greg Smith <greg@2ndQuadrant.com>
Re: Multiple index builds on same table - in one sweep? Scott Marlowe <scott.marlowe@gmail.com>
Re: Multiple index builds on same table - in one sweep? Greg Smith <greg@2ndquadrant.com>
Re: Multiple index builds on same table - in one sweep? Scott Marlowe <scott.marlowe@gmail.com>
Re: Multiple index builds on same table - in one sweep? Tom Lane <tgl@sss.pgh.pa.us>
Re: Multiple index builds on same table - in one sweep? Scott Marlowe <scott.marlowe@gmail.com>
Re: Multiple index builds on same table - in one sweep? Scott Marlowe <scott.marlowe@gmail.com>
Re: Multiple index builds on same table - in one sweep? Shaun Thomas <sthomas@peak6.com>
I have a table that I need to rebuild indexes on from time to time (records get loaded before indexes get build). To build the indexes, I use 'create index ...', which reads the entire table and builds the index, one at a time. I'm wondering if there is a way to build these indexes in parallel while reading the table only once for all indexes and building them all at the same time. Is there an index build tool that I missed somehow, that can do this? Thanks, Chris. best regards, chris -- chris ruprecht database grunt and bit pusher extraordinaíre
В списке pgsql-performance по дате отправления