Postgres Pro
Downloads
Home   >   mailing lists

Re: Alter timestamp without timezone to with timezone rewrites rows - Mailing list pgsql-hackers

From Noah Misch
Subject Re: Alter timestamp without timezone to with timezone rewrites rows
Date
Msg-id 20210116115342.GA1681052@rfd.leadboat.com
Whole thread Raw
In response to Re: Alter timestamp without timezone to with timezone rewrites rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Alter timestamp without timezone to with timezone rewrites rows  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Wed, Jan 13, 2021 at 10:28:26AM -0500, Tom Lane wrote:
> So a non-rewriting conversion would only be possible if local time is
> identical to UTC; which is true for few enough people that nobody has
> bothered with attempting the optimization.

PostgreSQL 12 and later do have that optimization.  Example DDL:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3c59263#patch4

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Parallel Inserts in CREATE TABLE AS
Next
From: Bharath Rupireddy
Date:
Subject: Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION