Re: how to speed up the index creation in GP?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux