Re: Assorted improvements in pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Assorted improvements in pg_dump
Дата
Msg-id 3788315.1635116321@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Assorted improvements in pg_dump  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> writes:
> On Sun, Oct 24, 2021 at 05:10:55PM -0400, Tom Lane wrote:
>> +               if (tbloids->len > 1)

> I think this should say
> +               if (tbloids->len > 0)

No, >1 is the correct test, because it's checking the string length
and we started by stuffing a '{' into the string.  Maybe needs a
comment.

> BTW, the ACL patch makes the overhead 6x lower (6.9sec vs 1.2sec) for pg_dump -t
> of a single, small table.  Thanks for that.

Yeah --- I haven't done any formal measurements of the case where you're
selecting a small number of tables, but I did note that it decreased a
good deal compared to HEAD.

            regards, tom lane



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pg_receivewal starting position
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: add retry mechanism for achieving recovery target before emitting FATA error "recovery ended before configured recovery target was reached"