Thread: how to speed up the index creation in GP?
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
Hi Suya, I think you should start with it http://www.postgresql.org/docs/9.2/static/indexes.html. On Wed, Jul 10, 2013 at 7:03 PM, Huang, Suya <Suya.Huang@au.experian.com> wrote: > 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 -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA Profile: http://www.linkedin.com/in/grayhemp Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979 Skype: gray-hemp Jabber: gray.ru@gmail.com