Forum: >>> Magnum BBS <<<

Dark
Log in

Username Password

Nice article on PostgreSQL 12 Generated Columns

From Pankaj Jangid@21:1/5 to All on Wed Oct 2 18:08:00 2019

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Christian Barthel@21:1/5 to Pankaj Jangid on Thu Oct 3 21:14:49 2019

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>

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Pankaj Jangid@21:1/5 to Christian Barthel on Fri Oct 4 14:22:46 2019

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Who's Online
Recent Visitors
- Keyop
  Sun May 22 22:47:14 2022
  from Huddersfield, West Yorkshire via Telnet
- Guest
  Mon May 23 18:23:12 2022
  from It via Telnet
- Keyop
  Wed May 25 18:11:15 2022
  from Huddersfield, West Yorkshire via Telnet
- Nemo
  Wed May 25 03:25:40 2022
  from Maryland via SSH

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	113
Nodes:	8 (1 / 7)
Uptime:	122:16:38
Calls:	2,501
Files:	8,692
Messages:	1,923,943