Re: [PERFORM] blocking index creation

2017-10-11 Thread Scott Marlowe
Try the queries here to check locks: https://wiki.postgresql.org/wiki/Lock_Monitoring On Wed, Oct 11, 2017 at 7:35 PM, Neto pr wrote: > Dear, > With alternative, I tested the creation using concurrency > (CREATE INDEX CONCURRENCY NAME_IDX ON TABLE USING HASH (COLUMN); > >

Re: [PERFORM] blocking index creation

2017-10-11 Thread Neto pr
Dear, With alternative, I tested the creation using concurrency (CREATE INDEX CONCURRENCY NAME_IDX ON TABLE USING HASH (COLUMN); from what I saw the index already appeared in the query result, because before this, the index did not even appear in the result, only the Lineitem table: SELECT

Re: [PERFORM] blocking index creation

2017-10-11 Thread Neto pr
Hello all, I ran the query on PG_STAT_ACTIVITY table (Select * From pg_stat_activity), see the complete result in this worksheet of the link below. https://sites.google.com/site/goissbr/img/Resultado_pg_stat_activity-create_index.xls The CREATE INDEX command line is identified with the orange

Re: [PERFORM] blocking index creation

2017-10-11 Thread Tomas Vondra
On 10/11/2017 04:11 PM, Neto pr wrote: > > 2017-10-11 10:46 GMT-03:00 Laurenz Albe >: > > Neto pr wrote: > > When creating index on table of approximately 10GB of data, the DBMS > hangs (I think), > > because even after

Re: [PERFORM] blocking index creation

2017-10-11 Thread Neto pr
2017-10-11 10:46 GMT-03:00 Laurenz Albe : > 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

Re: [PERFORM] blocking index creation

2017-10-11 Thread Laurenz Albe
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

[PERFORM] blocking index creation

2017-10-11 Thread Neto pr
Hello all, My scenario is: postgresql 10, Processor Xeon 2.8GHz / 4-core- 8gb Ram, OS Debian 8. 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