Neto pr wrote: > When creating index on table of approximately 10GB of data, the DBMS hangs (I > think), > because even after waiting 10 hours there was no return of the command. > It happened by creating Hash indexes and B + tree indexes. > However, for some columns, it was successfully (L_RETURNFLAG, L_PARTKEY).
> If someone has a hint how to speed up index creation so that it completes > successfully. Look if CREATE INDEX is running or waiting for a lock (check the "pg_locks" table, see if the backend consumes CPU time). Maybe there is a long-running transaction that blocks the ACCESS EXCLUSIVE lock required. It could also be a prepared transaction. Yours, Laurenz Albe -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
