Hi, looking for a little advice... Nightly, I run a script that does the following (in a nutshell): drop most of the indexes in a particular schema; load a large amount of data into this schema; finally recreate the indexes. The create index process seems to be CPU-bound. The server has four CPUs but postmaster is only using one. Is there a way to tell Postgres to build in parallel? For instance in Oracle one can run the following to have four processes build an index in parallel: CREATE INDEX emp_ix ON emp (emp_id) PARALLEL (DEGREE 4); I could always create each index from a separate script in parallel, but that would be less flexible (can't easily modify degree for instance) and take some serious redesign... No luck searching the docs, but I'd just like to be sure that there isn't such a feature... Or if there's a better way to tackle this problem I'd love to hear it. So, any input would be appreciated. Thanks, Mark
