[PERFORM] how to speed up the index creation in GP?

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

Re: [PERFORM] Process in state BIND, authentication, PARSE

Jeison Bedoya wrote: > Ram: 128GB > max_connections = 900 > temp_buffers = 128MB Besides the concerns already expressed about work_mem, temp_buffers could be a big problem.  If a connection uses temp tables it acquires up to 128MB, *and holds on it reserved for caching temp tables for that con

Re: [PERFORM] Performance autovaccum

In our use case, the default autovacuum settings did not work, I guess we are in the 5% group of users. The default settings were too aggressive when it ran against some of our larger tables (example: 100M rows by 250 columns) in our front end OLTP database causing severe performance degradati