Path: csiph.com!aioe.org!.POSTED.2903o5RmxRAUctKC432rfg.user.gioia.aioe.org!not-for-mail
From: Pankaj Jangid <pankaj.jangid@gmail.com>
Newsgroups: comp.databases.postgresql
Subject: Re: Nice article on PostgreSQL 12 Generated Columns
Date: Fri, 04 Oct 2019 14:22:46 +0530
Organization: Code is Great!
Lines: 19
Message-ID: <m2bluwq4dd.fsf@gmail.com>
References: <m2d0ffnx07.fsf@gmail.com> <87eezt1w0m.fsf@barthel.ch>
NNTP-Posting-Host: 2903o5RmxRAUctKC432rfg.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain
X-Complaints-To: abuse@aioe.org
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (darwin)
Cancel-Lock: sha1:gDD6/s4FSZ4kvQdcCauRQ3YV3eA=
X-Notice: Filtered by postfilter v. 0.9.2
Xref: csiph.com comp.databases.postgresql:880

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