Re: Followup Timestamp to timestamp with TZ conversion

2021-07-23 Thread Peter Volk
pe of optimisation should / could also apply to indexes as well as the columns used in partitions Thanks, Peter On Thu, Jul 22, 2021 at 5:29 PM Tom Lane wrote: > > Peter Volk writes: > > The problem is that I have a 60TB+ PG installation for which we need to > > modify all o

Followup Timestamp to timestamp with TZ conversion

2021-07-22 Thread Peter Volk
Hi, this is a followup to a performance optimization during the conversion of a column from a timestamp column to a "timestamp with tz" column. The initial patch I am referring to is this one: https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=3c59263#patch4 and the previous disc