Re: pg_restore & locks

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: pg_restore & locks
Дата
Msg-id CAOC+FBU_XMidH-xnECxbT-e8aEwQwkX+DHFu9ghcGoL7SZL1nQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_restore & locks  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin
Дерево обсуждения
I should add all of the locks are REFRESH MATERIALIZED VIEW... statements.

On Sun, Jun 13, 2021 at 8:37 AM Wells Oliver <wells.oliver@gmail.com> wrote:
Is it normal for a parallel pg_restore to result in locks? Will these usually resolve themselves?

The restore is running with 16 jobs into an RDS instance and at the moment pg_locks has about 243 AccessShareLock, 35 ExclusiveLock, 24 AccessExclusiveLock, and 8 ShareLock...

Will these just resolve as queries finish, or is it a concern? The restore has been running a long time.

pg_restore command:

time pg_restore \
--host=${HOST} \
--user=postgres \
--format=directory \
--dbname=${DB} \
--jobs ${JOBS} \ 

Where JOBS here 16.
--


--

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

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: pg_restore: warning: invalid creation date in header
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore: warning: invalid creation date in header