Nice article on PostgreSQL 12 Generated Columns

[Pankaj Jangid]

Found a very nice article about PostgreSQL 12 Generated Columns. I
thought this might be useful for everyone. Hence sharing.

https://pgdash.io/blog/postgres-12-generated-columns.html

--
Pankaj Jangid

[Christian Barthel]

Interesting, indeed. Version 12 has been released today with
many other features.
I am mostly interested in the performance improvements of CTEs:
https://paquier.xyz/postgresql-2/postgres-12-with-materialize/
--
Christian Barthel <b...@online.de>

[Pankaj Jangid]

Christian Barthel <b...@online.de> writes:

> Pankaj Jangid <pankaj...@gmail.com> writes:
>> https://pgdash.io/blog/postgres-12-generated-columns.html
>
> Interesting, indeed. Version 12 has been released today with
> many other features.
> I am mostly interested in the performance improvements of CTEs:
> https://paquier.xyz/postgresql-2/postgres-12-with-materialize/

There was a user-story on the mailing-list. There are lots of
performance improvements in 12. He had a backup/archiving script that
runs at the end of month. He reported saving of 10 hours for about 3-4TB
of data. This was without changing the script.

CTEs is also a widely used concept. This will really help many.

--
Pankaj Jangid