Hi,
We are trying to create a index concurrently but, at least apparently, it
hangs in a infinite loop and never ends.
Our version:
flip=# select version();
version
PostgreSQL 9.3.12 on x86_64-unknown-linux-gnu
pid = l.pid)
>JOIN pg_stat_user_tables t ON (l1.relation = t.relid)
>WHERE w.waiting;
>
>
> On Mon, May 9, 2016 at 11:50 AM, Joshua D. Drake
> wrote:
>
>> On 05/09/2016 05:04 AM, Robert Anderson wrote:
>>
>>> Hi,
>>>
>>> We are tryi
| CREATE INDEX CONCURRENTLY index_texto
| ON flip_pagina_edicao
| USING hash
| (texto COLLATE pg_catalog."default");
postgres=#
2016-05-09 14:20 GMT-03:00 Tom Lane :
> Robert Anderson writes:
> > There
ong has it been taking?
backend_start| 2016-05-07 11:48:39.218398-03
More than 50 hours.
What is your maintenance_work_mem set to?
maintenance_work_mem = 352MB
2016-05-09 14:34 GMT-03:00 Joshua D. Drake :
> On 05/09/2016 10:32 AM, Robert Anderson wrote:
>
>> Only one li
