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