From: | Erwin Brandstetter <brandstetter(at)falter(dot)at> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: Wrong statistics for overloaded functions |
Date: | 2011-07-07 12:08:52 |
Message-ID: | 4E15A1D4.2070506@falter.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
On 07.07.2011 08:52, Guillaume Lelarge wrote:
> On Wed, 2011-07-06 at 21:22 +0200, Erwin Brandstetter wrote:
>> Aloha!
>>
>> I have been observing irregularities in the function statistics for some time. Now I have investigated and believe to have found the cause.
>> Everything is here, including a proposed fix:
>> http://code.pgadmin.org/trac/ticket/325
>>
> The fix you propose requires from us to write a patch for PostgreSQL
> (which won't be available to users before 9.2) for something we can
> already do right into pgAdmin. Instead of filtering with the name of the
> schema and the function, we should use its OID. This way, we could fix
> 1.12, and 1.14 really quickly.
Yeah, that's even better. Makes the query simpler, too.
I was unsure whether funcid was known at the time of the query.
I do wonder, however, why the function arguments, part of the function signature, would not be included in pg_catalog.pg_stat_user_functions.
Would you think this is worthy of a suggestion to the postgres people?
Regards
Erwin
From | Date | Subject | |
---|---|---|---|
Next Message | pgAdmin Trac | 2011-07-07 12:16:32 | Re: [pgAdmin III] #325: Wrong statistics for overloaded functions |
Previous Message | Guillaume Lelarge | 2011-07-07 06:52:24 | Re: Wrong statistics for overloaded functions |