From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Can we get rid of repeated queries from pg_dump? |
Date: | 2021-08-28 14:28:50 |
Message-ID: | 1004390.1630160930@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> On Fri, Aug 27, 2021 at 05:23:23PM -0400, 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?
> 23 functions with 0 arguments, 52 with 1, and the max is 5 arguments - two
> functions have these.
> Not sure if it matters but there is a lot of enums. 83 of them. And they have
> up to 250 elements (2 such types).
Hmm, no, I don't see any getFormattedTypeName calls in dumpEnumType.
There are two of 'em in dumpCast though. Does this DB by chance
have a ton of user-defined casts?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2021-08-28 16:18:52 | Re: Unexpected block ID found when reading data |
Previous Message | Tiemen Ruiten | 2021-08-28 13:15:24 | Re: Please help: pgAdmin 4 on Amazon Linux 2 |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dilger | 2021-08-28 16:30:12 | Re: Use extended statistics to estimate (Var op Var) clauses |
Previous Message | Zhihong Yu | 2021-08-28 14:06:13 | Re: Use extended statistics to estimate (Var op Var) clauses |