Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> So the ALTER TABLE trick is not needed in 9.0, but is useful in previous
> releases. There are optimizations to avoid the table rewrite in certain
> cases in 9.2:
> According to that page, though, a change of varchar(36) to varchar(36)
> would still require a table rewrite, which doesn't make sense to me. Is
> the wiki page inaccurate maybe?
Yeah - you can easily convince yourself by timing it that no rewrite
happens in 9.2.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2012-08-23 19:45:46|
|Subject: Re: BUG #6728: revoke grant cascade behaviour|
|Previous:||From: Jeff Davis||Date: 2012-08-23 16:45:25|
|Subject: Re: BUG #7501: Unique index fails to check uniqueness on