On 5 December 2012 09:46, John R Pierce <pierce@hogranch.com> wrote:
> On 12/5/2012 1:42 AM, Simon Riggs wrote:
>>
>> I think we need a parameter called
>>
>> schema_change_reporting = off (default) | on [USERSET]
>>
>> which displays relevant statistics/reports about the actions taken by
>> DDL statements. That will also highlight locks and the need to reduce
>> their lock levels.
>
>
> where does this get displayed? is it just tossed into the postgres log
> files?
Good question. Where would you like?
It needs to be per-session rather than global.
-- Simon Riggs http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services