Re: Alter timestamp without timezone to with timezone rewrites rows

Поиск
Список
Период
Сортировка
От Noah Misch
Тема Re: Alter timestamp without timezone to with timezone rewrites rows
Дата
Msg-id 20210116115342.GA1681052@rfd.leadboat.com
обсуждение исходный текст
Ответ на Re: Alter timestamp without timezone to with timezone rewrites rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Alter timestamp without timezone to with timezone rewrites rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Parallel Inserts in CREATE TABLE AS
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION