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
- Jc1571
  Sat Oct 31 09:23:43 2026
  from Vancouver, Bc via Telnet
- Beg5210
  Sat Oct 31 07:44:00 2026
  from Melbourne, Aus via Telnet
- Beg5210
  Sat Oct 31 07:42:02 2026
  from Melbourne, Aus via Telnet
- Skreek
  Sat Oct 31 01:26:37 2026
  from Leeds, England via Telnet
- Ashenfieldx
  Sat Oct 31 00:53:18 2026
  from Guelph, Ontario via Telnet
- Rixter
  Fri Oct 30 23:01:34 2026
  from Madison, Nc via Telnet
- Brianm
  Fri Oct 30 22:44:03 2026
  from Glasgow via Raw
- Amstrad Ppc
  Fri Oct 30 21:43:10 2026
  from Wiltshire via SSH

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	796
Nodes:	16 (3 / 13)
Uptime:	140:01:43
Calls:	13,182
Calls today:	5
Files:	15,481
Messages:	6,579,033
Posted today:	2