Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a
Дата
Msg-id 20200915023320.GI2183@paquier.xyz
обсуждение исходный текст
Ответ на Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a  (Julien Rouhaud <rjuju123@gmail.com>)
Ответы Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a
Список pgsql-hackers
On Tue, Jul 14, 2020 at 11:14:50AM +0200, Julien Rouhaud wrote:
> Note that those extraneous queries were found while trying to dump
> data out of a corrupted database.  The issue wasn't an excessive
> runtime but corrupted catalog entries, so bypassing this code (since I
> was only interested in the data anyway) was simpler than trying to
> recover yet other corrupted rows.

Yeah, I don't see actually why this argument can prevent us from doing
a micro optimization if it proves to work correctly.
--
Michael

Вложения

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: logtape.c stats don't account for unused "prefetched" block numbers
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a