Re: Can we get rid of repeated queries from pg_dump?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Can we get rid of repeated queries from pg_dump?
Дата
Msg-id 901655.1630104662@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Can we get rid of repeated queries from pg_dump?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 8/27/21 2:23 PM, Tom Lane wrote:
>> Those queries are coming from getFormattedTypeName(), which is used
>> for function arguments and the like.  I'm not quite sure why Hubert
>> is seeing 5000 such calls in a database with only ~100 functions;
>> surely they don't all have an average of 50 arguments?

> Could be.

Maybe.  I'm disturbed by the discrepancy between my result (about
10% of pg_dump's queries are these) and Hubert's (over 50% are).
I'd like to know the reason for that before we push forward.

            regards, tom lane



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

Предыдущее
От: ourdiaspora
Дата:
Сообщение: Re: use fopen iso-8859-1 resource
Следующее
От: Gilar Ginanjar
Дата:
Сообщение: Re: Unexpected block ID found when reading data