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 <[email protected]> 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 <[email protected]>

--- 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 <[email protected]> writes:

Pankaj Jangid <[email protected]> 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
- Krenn
  Sun Jun 7 10:02:33 2026
  from Sydney, Nsw via Telnet
- Spearb0y
  Sun Jun 7 07:41:05 2026
  from Massachusetts via SSH
- Krenn
  Sun Jun 7 03:07:26 2026
  from Sydney, Nsw via Telnet
- Krenn
  Sun Jun 7 01:30:12 2026
  from Sydney, Nsw via Telnet
- Centurion
  Sat Jun 6 23:27:30 2026
  from Berea, Ohio via Telnet
- Ab Cadd
  Sat Jun 6 15:42:53 2026
  from Sheboygan, Wi via Telnet
- Centurion
  Sat Jun 6 15:32:28 2026
  from Berea, Ohio via Telnet
- Krenn
  Sat Jun 6 11:38:56 2026
  from Sydney, Nsw via Telnet

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	715
Nodes:	16 (1 / 15)
Uptime:	164:48:13
Calls:	12,096
Calls today:	4
Files:	15,001
Messages:	6,517,802