Nice article on PostgreSQL 12 Generated Columns

Thread View: comp.databases.postgresql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Pankaj Jangid Wed, 02 Oct 2019 18:08

#3422

Author: Pankaj Jangid
Date: Wed, 02 Oct 2019 18:08

6 lines
202 bytes

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

Re: Nice article on PostgreSQL 12 Generated Columns

#3423

Author: Christian Barthe
Date: Thu, 03 Oct 2019 21:14

12 lines
489 bytes

Pankaj Jangid <pankaj.jangid@gmail.com> writes:

> 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

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 <bch@online.de>

Re: Nice article on PostgreSQL 12 Generated Columns

#3424

Author: Pankaj Jangid
Date: Fri, 04 Oct 2019 14:22

18 lines
712 bytes

Christian Barthel <bch@online.de> writes:

> Pankaj Jangid <pankaj.jangid@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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads