| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: how to speed up the index creation in GP? |
| Date: | 2013-07-15 04:33:57 |
| Message-ID: | CAL_0b1vwSffNLfAFyGy2hDhbk1BY+qrzAv51+RAKhBq+K_QHMg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(dot)Huang(at)au(dot)experian(dot)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(dot)ru(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Fehrle | 2013-07-15 16:12:20 | Re: Trying to eliminate union and sort |
| Previous Message | Jeff Janes | 2013-07-13 21:29:20 | Re: In progress INSERT wrecks plans on table |