[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] how to speed up the index creation in GP?
From:       Sergey Konoplev <gray.ru () gmail ! com>
Date:       2013-07-15 4:33:57
Message-ID: CAL_0b1vwSffNLfAFyGy2hDhbk1BY+qrzAv51+RAKhBq+K_QHMg () mail ! gmail ! com
[Download RAW message or body]

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]