Re: ALTER TABLE ... NOREWRITE option

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ALTER TABLE ... NOREWRITE option
Date: 2012-12-05 15:01:33
Message-ID: 5161.1354719693@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

John R Pierce <pierce(at)hogranch(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-12-05 15:07:41 Re: autovacuum truncate exclusive lock round two
Previous Message Cédric Villemain 2012-12-05 14:58:31 Re: Review: Dumping an Extension's Script