Re: Create index concurrently hanging with big table on pgsql 9.3.12

On 05/09/2016 10:32 AM, Robert Anderson wrote:
> Only one line returned:
>
> postgres=# select * from pg_stat_activity where pid=3990;
> -[ RECORD 1 ]----+----------------------------------------
> datid | 16434
> datname | flip
> pid | 3990
> usesysid | 10
> usename | postgres
> application_name | psql
> client_addr |
> client_hostname |
> client_port | -1
> backend_start | 2016-05-07 11:48:39.218398-03
> xact_start | 2016-05-07 11:48:43.417734-03
> query_start | 2016-05-07 11:48:43.417734-03
> state_change | 2016-05-07 11:48:43.417742-03
> waiting | f
> state | active
> query | CREATE INDEX CONCURRENTLY index_texto
> | ON flip_pagina_edicao
> | USING hash
> | (texto COLLATE pg_catalog."default");

So it isn't blocked by a lock. You still haven't stated why you think it
is blocked? How long has it been taking? What is your
maintenance_work_mem set to?

JD

--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.