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@xxxxxxxxxxxxxxx> 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@xxxxxxxxx -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance