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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to