how to speed up the index creation in GP?

From: "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: how to speed up the index creation in GP?
Date: 2013-07-11 02:03:48
Message-ID: D83E55F5F4D99B4A9B4C4E259E6227CD8F4791@AUX1EXC01.apac.experian.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Guys,

I'm new to Postgresql, we have a Greenplum cluster and need to create many indexes on the database. So my question is:

Is there any performance tips for creating index on Postgres?
how to monitor the progress the creation process?

Thanks and best regards,
Suya Huang

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Abhijit Menon-Sen 2013-07-11 05:09:58 Re: [PERFORM] In progress INSERT wrecks plans on table
Previous Message Josh Berkus 2013-07-10 16:47:34 Re: [PERFORM] In progress INSERT wrecks plans on table