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
- Bob Worm
  Tue Jul 28 16:01:18 2026
  from Wales, Uk via Telnet
- Rixter
  Tue Jul 28 13:42:46 2026
  from Madison, Nc via Telnet
- Krenn
  Tue Jul 28 11:59:57 2026
  from Sydney, Nsw via Telnet
- Rixter
  Tue Jul 28 01:23:48 2026
  from Madison, Nc via Telnet
- Centurion
  Mon Jul 27 22:50:42 2026
  from Berea, Ohio via Telnet
- Ataricrypt
  Mon Jul 27 19:19:17 2026
  from England via Telnet
- Bob Worm
  Mon Jul 27 15:19:55 2026
  from Wales, Uk via Telnet
- Rixter
  Mon Jul 27 13:04:59 2026
  from Madison, Nc via Telnet

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	741
Nodes:	16 (2 / 14)
Uptime:	50:58:08
Calls:	12,444
Calls today:	4
Files:	15,192
Messages:	6,537,160