Groups > comp.databases.postgresql > #880

Re: Nice article on PostgreSQL 12 Generated Columns

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> (permalink)
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

Show key headers only | View raw

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

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

Nice article on PostgreSQL 12 Generated Columns Pankaj Jangid <pankaj.jangid@gmail.com> - 2019-10-02 18:08 +0530
  Re: Nice article on PostgreSQL 12 Generated Columns Christian Barthel <bch@online.de> - 2019-10-03 21:14 +0200
    Re: Nice article on PostgreSQL 12 Generated Columns Pankaj Jangid <pankaj.jangid@gmail.com> - 2019-10-04 14:22 +0530

csiph-web