Re: psql \copy hanging

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: psql \copy hanging
Дата
Msg-id CAKoxK+5qWTmmEeGFU8nG3JxGuUKSMUnFtUFkEcjCCYLCWSqaew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql \copy hanging  ("Arnaud L." <arnaud.listes@codata.eu>)
Список pgsql-general
On Tue, Aug 27, 2019 at 9:54 AM Arnaud L. <arnaud.listes@codata.eu> wrote:
> Any other idea ? I'll change the lines order for tonight's run, but that
> is not what I'd call a solution...

Does it hangs against the same line content or the same line number?
Are you able to run the script automatically during working hours (to
avoid firewalling or upgrades running in parrallel to your nightly
script execution)?
Any chance something is querying the same data and a lock blocks the
transaction (pg_locks)?

Just throwing on the table some desperate ideas....

Luca



В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: cannot CREATE INDEX because it has pending trigger events
Следующее
От: "Arnaud L."
Дата:
Сообщение: Re: psql \copy hanging