Postgres Pro
Downloads
Home   >   mailing lists

Re: how to speed up the index creation in GP? - Mailing list pgsql-performance

From Sergey Konoplev
Subject Re: how to speed up the index creation in GP?
Date
Msg-id CAL_0b1vwSffNLfAFyGy2hDhbk1BY+qrzAv51+RAKhBq+K_QHMg@mail.gmail.com
Whole thread Raw
In response to how to speed up the index creation in GP?  ("Huang, Suya" <Suya.Huang@au.experian.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: In progress INSERT wrecks plans on table
Next
From: Brian Fehrle
Date:
Subject: Re: Trying to eliminate union and sort