3r3309. 3r3-31.  3r3309.
 3r3309. POSTGRESSO special edition, dedicated to the release of the official release of version 11.
 3r3309.
 3r3309. Outdoor PostgreSQL holiday. After four, beta came out PostgreSQL 11 General Availability that is the official version. In 3r316. the announcement of
there is even a welcome word Bruce Momjan : “In preparing this release, the community was especially concerned about adding the functionality necessary to work with very large databases. It has been proven that PostgreSQL works well with transactional workloads, and now the new version, PostgreSQL 1? will also make it easier for developers to create applications for Big Data. ”
 3r3309.
 3r3309. In release notes produce
 3r3309.
 3r3309.
 3r3309. 3r3384. partitioning: 3r3356.  3r3309. 3r3384. added hash partitioning;
 3r3309. 3r3384. PRIMARY KEY, FOREIGN KEY, indexes (see below for this topic) and triggers;
 3r3309. 3r3384. the default section for entries that went beyond the boundaries of the created sections;
 3r3309. 3r3384. UPDATE by partitioning key can now automatically move the record to the corresponding section;
 3r3309. 3r3384. PostgreSQL has learned to exclude unnecessary sections (partition pruning) during the execution of SELECT queries;  3r3309.  3r3309. 3r3384. parallelization:

•  3r3309. 3r3384. Now you can create an index in parallel in the case of B-tree;  3r3309. 3r3384. with CREATE TABLE AS, CREATE MATERIALIZED VIEW and in some cases queries with UNION;  3r3309. 3r3384. improved performance in parallel HASH JOIN and SEQUENTIAL SCAN;  3r3309.

 3r3309. 3r3384. new stored procedures have appeared, and transaction management is possible in them;  3r3309. 3r3384. JIT compilation of some queries, gain on the calculation of expressions;  3r3309. 3r3384. window functions now support all frame options of the SQL: 2011 standard, including RANGE distances for PRECEDING /FOLLOWING, GROUPS mode, the ability to exclude lines from the frame;  3r3309. 3r3384. ​​covering indexes appeared.[не покрывающие, а инклюзивные, строго говоря — прим. POSTGRESSO] that use the INCLUDE clause with CREATE INDEX;  3r3309. 3r3384. from the “miscellaneous” section: ALTER TABLE ADD COLUMN with NOT NULL values ​​by default: this version of the command now does not overwrite all the rows in the table and, therefore, works quickly.  3r3309.
 3r3309. It was back in mid-April.
 3r3309.
 3r3309. Postgressist from HPE regularly publish a detailed summary of the functionality. After the April Feature freeze, she was this is (this PDF contains a brief summary of innovations, and details, and examples).
 3r3309.
 3r3309. Not quite clear, nevertheless, are the super-boring raptures (see below the reaction of Lucas Fitt) about this version. A lot of useful things have been done, but very important things have yet to be completed, but there are directions in which it’s not that the horse doesn’t roll, but this is only the light at the beginning of the tunnel. For example, much has been done in partitioning, no doubt, but it is still impossible to refer to a partitioned table using FOREIGN KEY. You can create a FOREIGN KEY, but in the partitioned table itself. There are no global indexes.
 3r3309.
 3r3309. JIT /LLVM appeared, but immediately disappeared from the default configuration: by default it is turned off. And this is no accident, because in some cases it does not accelerate, but introduces unnecessary overheads.
 3r3309.
 3r3309. Not included in the new version of the large patches with functions to work with 3r3156. JSON /JSONB .
 3r3309.
 3r3309. Behind the plug-in storage engines ( Pluggable storage ) And including, zheap (i.e. an Oracle-like UNDO that works without VACUUM) many follow with a sinking heart. They are in an embryonic state, they have not even yet resolved the API. The overview of possibilities in this direction is here is .
 3r3309.
 3r3309. But it was just a reminder of what remains to be. Work on the new and unfinished old is in full swing, the direction of development is understandable.
 3r3309.
 3r3309. 3r3190. Articles 3r3191.
 3r3309. New in Postgres 11: Monitoring JIT performance, Auto Prewarm & Stored Procedures
 3r3309. Lucas Fitl (Lukas Fittl) not only 3r3152. lists the most important innovations , but also leads performance evaluations, listings, plans. Lucas explains what's new in extension for pre-heating base (pg_prewarm) , reminds about the features of stored procedures, tests JIT. The conclusion is ultra-optimistic: it looks like it will be The best release of PostgreSQL .
 3r3309.
 3r3309. Postgres 11 - a First Look
 3r3309. Craig Kirstins (Craig Kerstiens) draws attention including features that are not described above, recalls changes in statistics, for example. Or about see below.
 3r3309.
 3r3309. Adding new table columns with default values ​​in PostgreSQL 11
 3r3309. 3r33180. An article about a curious author patch, Andrew Dunstan (Andrew Dunstan)
from 2ndQuadrant . Now, for example, not only static values ​​can be specified in the default column, but also CURRENT_TIMESTAMP or random ().
 3r3309.
 3r3309. 3r3190. At conferences and on webinars on PostgreSQL 11
 3r3309. Peter Ayzenturut (Peter Eisentraut) of 2ndQuadrant held a webinar on PostgreSQL 11 innovations. Record supplemented 3r33200. Answers to unanswered questions
on the webinar.
 3r3309.
 3r3309. On 3r33255. PGCONF.EU [/b] in Lisbon (here is 3r3208. program 3r3-33298.) a review report is scheduled, of course: 3r-?375. Magnus Hagander [/i] (Magnus Hagander)
 3r3309. What's new in PostgreSQL 11? and to him a pair of
 3r3309. What is old in PostgreSQL 11? Devrima Gunduz (Devrim Gündüz).
 3r3309. Towards more efficient query plans: PostgreSQL 11 and beyond Alexandra Kuzmenkova (Postgres Professional), in which not only (and even not so much) closed features, but also what is still in the work will be mentioned.
 3r3309. Also in the program there are reports
 3r3309. PostgreSQL worst practices Ilya Kosmodemyansky ( Data Egret )
 3r3309. Do you need a Full-Text Search in PostgreSQL? Oleg Bartunov (Postgres Professional) ,
 3r3309. Advanced PostgreSQL Backup and Recovery methods Anastasia Lubennikova (Postgres Professional)
 3r3309.
 3r3309.
 3r3309. Subscribe to the channel. postgresso !
 3r3309.
 3r3309. Send your ideas and suggestions to: [email protected]
 3r3309. Previous issues: # 10 , # 9 , # 8 , # 7 , # 6 , # 5 , # 4 , # 3 , # 2 , # 1 3r3305. 3r3309. 3r3309. 3r3302. ! function (e) {function t (t, n) {if (! (n in e)) {for (var r, a = e.document, i = a.scripts, o = i.length; o-- ;) if (-1! == i[o].src.indexOf (t)) {r = i[o]; break} if (! r) {r = a.createElement ("script"), r.type = "text /jаvascript", r.async =! ? r.defer =! ? r.src = t, r.charset = "UTF-8"; var d = function () {var e = a.getElementsByTagName ("script")[0]; e.parentNode.insertBefore (r, e)}; "[object Opera]" == e.opera? a.addEventListener? a.addEventListener ("DOMContentLoaded", d,! 1): e.attachEvent ("onload", d ): d ()}}} t ("//mediator.mail.ru/script/2820404/"""_mediator") () (); 3r3303. 3r3309. 3r3305. 3r3309. 3r3309. 3r3309. 3r3309.