Re: Server instrumentation patch

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
Cc: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Server instrumentation patch
Date: 2005-06-24 16:48:10
Message-ID: 034301c578dc$81cb26c0$0f01a8c0@zaphod
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andreas Pflug wrote:

> Michael Paesold wrote:
>
>> Andreas Pflug wrote:
>>
>>>> For the second, please supply a patch that moves _all_ of dbsize into
>>>> the main server. I think we have agreement on that.
>>>>
>>>
>>> I don't think so. As I mentioned, those views are broken. Do you want
>>> them to be in core anyway?
>>
>>
>> Why is e.g. this one broken:
>> int8 database_size(name) - Return the size of the database in
>> bytes (by name)
>>
>> It should do the same as the one with the oid except that it will resolve
>> the name first, no? If not it should be fixed, not dropped. I understand
>> you'd like to have those functions for the GUI frontends, but what about
>> psql users? For many people it will be hard work to type the subquery to
>> get the database oid.
>>
>> I vote for all (possibly corrected) functions to be moved into core.
>
> You're correct about the functions, but I was talking about the views.
> "WHERE name = $1" won't respect the schema, contrary to the current doc.

Oh, I am sorry for not reading carefully enough. Didn't know there were
views at all. So if they are broken and cannot be fixed, well...

Best Regards,
Michael Paesold

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paesold 2005-06-24 16:53:25 Re: Server instrumentation patch
Previous Message Josh Berkus 2005-06-24 16:21:56 Re: [PATCHES] O_DIRECT for WAL writes