Re: ALTER TABLE ... NOREWRITE option - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER TABLE ... NOREWRITE option
Date
Msg-id 5161.1354719693@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE ... NOREWRITE option  (John R Pierce <pierce@hogranch.com>)
Responses Re: ALTER TABLE ... NOREWRITE option
List pgsql-hackers
John R Pierce <pierce@hogranch.com> writes:
> 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?

And perhaps more to the point, what's the advantage compared to
good old "log_statement = ddl"?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Review: Dumping an Extension's Script
Next
From: Robert Haas
Date:
Subject: Re: autovacuum truncate exclusive lock round two