pg_dump LOCK TABLE ONLY question

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема pg_dump LOCK TABLE ONLY question
Дата
Msg-id CAP_rww=n_v48D0Q97MfNzCQj=iWJKXKT82OEVdz3gBE7HRFCSQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump LOCK TABLE ONLY question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi.

I'm running pg_dump constrained to one schema. It appears that pg_dump runs

"LOCK TABLE %s IN ACCESS SHARE MODE" for each table.

Naturally it makes sense, but...

This schema has a table that serves as parent for thousands of child
tables (via INHERITS).

So effectively, to dump this schema, I have to LOCK all these tables
not only parent.

pg_dump does it automatically, I checked in current trunk - it does
not add ONLY keyword. Should it?

I wonder if it it counts as a bug.
If not a bug, maybe it counts as a feature request?

Thanks.



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

Предыдущее
От: "Jinyu Zhang"
Дата:
Сообщение: Patch: Optimize memory allocation in function 'bringetbitmap'
Следующее
От: David Rowley
Дата:
Сообщение: Re: PATCH: use foreign keys to improve join estimates v1