Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #880

Re: Nice article on PostgreSQL 12 Generated Columns

Show all headers | 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