Re: PostgreSQL 12 Beta 1 press release draft

2019-05-23 Thread Pantelis Theodosiou
On Thu, May 23, 2019 at 4:36 PM Pantelis Theodosiou wrote: > > On Thu, May 23, 2019 at 1:01 PM Jonathan S. Katz > wrote: > >> On 5/23/19 1:45 AM, David Rowley wrote: >> > On Thu, 23 May 2019 at 15:31, Jonathan S. Katz >> wrote: >> >> Attached is >> >> v3 of the patch, along with a diff. >> > >>

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-23 Thread Pantelis Theodosiou
On Thu, May 23, 2019 at 1:01 PM Jonathan S. Katz wrote: > On 5/23/19 1:45 AM, David Rowley wrote: > > On Thu, 23 May 2019 at 15:31, Jonathan S. Katz > wrote: > >> Attached is > >> v3 of the patch, along with a diff. > > > > Minor details, but this query is not valid: > > > >> WITH c AS MATERIALI

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-23 Thread Jonathan S. Katz
On 5/23/19 1:45 AM, David Rowley wrote: > On Thu, 23 May 2019 at 15:31, Jonathan S. Katz wrote: >> Attached is >> v3 of the patch, along with a diff. > > Minor details, but this query is not valid: > >> WITH c AS MATERIALIZED ( >> SELECT * FROM a WHERE a.x % 4 >> ) >> SELECT * FROM c JOIN d ON

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-22 Thread David Rowley
On Thu, 23 May 2019 at 15:31, Jonathan S. Katz wrote: > Attached is > v3 of the patch, along with a diff. Minor details, but this query is not valid: > WITH c AS MATERIALIZED ( > SELECT * FROM a WHERE a.x % 4 > ) > SELECT * FROM c JOIN d ON d.y = a.x; a.x % 4 is not a boolean clause, and "a"

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-22 Thread Jonathan S. Katz
Hi Ilmari, On 5/22/19 6:52 PM, Dagfinn Ilmari Mannsåker wrote: > Hi Jonathan, > > "Jonathan S. Katz" writes: > >> If you have additional feedback please provide it before 7am EDT >> tomorrow. > > Thanks for writing this up. Below are some things I noticed when > reading through (disclaimer: I

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-22 Thread Dagfinn Ilmari Mannsåker
Hi Jonathan, "Jonathan S. Katz" writes: > If you have additional feedback please provide it before 7am EDT > tomorrow. Thanks for writing this up. Below are some things I noticed when reading through (disclaimer: I'm not a native speaker). > PostgreSQL 12 extends the abilities of several of t

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-22 Thread Jonathan S. Katz
On 5/21/19 11:39 PM, Jonathan S. Katz wrote: > Hi, > > Attached is a draft of the PG12 Beta 1 press release that is going out > this Thursday. The primary goals of this release announcement are to > introduce new features, enhancements, and changes that are available in > PG12, as well as encourag

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-22 Thread Andres Freund
Hi, > ### Indexing Performance, Functionality, and Management > > PostgreSQL 12 improves the overall performance of the standard B-tree indexes > with improvements to the overall space management of these indexes as well. > These improvements also provide an overall reduction of bloating when usi

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-22 Thread Robbie Harwood
"Jonathan S. Katz" writes: > Attached is a draft of the PG12 Beta 1 press release that is going out > this Thursday. The primary goals of this release announcement are to > introduce new features, enhancements, and changes that are available in > PG12, as well as encourage our users to test and p

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-21 Thread Amit Langote
On 2019/05/22 15:47, David Rowley wrote: > On Wed, 22 May 2019 at 15:39, Jonathan S. Katz wrote: >> PostgreSQL 12 also provides improvements to the performance of both >> using `COPY` with a partitioned table as well as the `ATTACH PARTITION` >> operation. Additionally, the ability to use foreign

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-21 Thread David Rowley
On Wed, 22 May 2019 at 15:39, Jonathan S. Katz wrote: > Speaking of feedback, please provide me with your feedback on the > technical correctness of this announcement so I can incorporate changes > prior to the release. Seems like a pretty good summary. Thanks for writing that up. Couple notes f

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-21 Thread Justin Pryzby
Find some corrections inline. On Tue, May 21, 2019 at 11:39:38PM -0400, Jonathan S. Katz wrote: > PostgreSQL 12 Beta 1 Released > = > > The PostgreSQL Global Development Group announces that the first beta release > of > PostgreSQL 12 is now available for download. Th

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-21 Thread Erik Rijkers
On 2019-05-22 05:39, Jonathan S. Katz wrote: Speaking of feedback, please provide me with your feedback on the technical correctness of this announcement so I can incorporate changes prior to the release. Here are a few changes. Main change: generated columns exist only in the STORED variety.

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-21 Thread Corey Huinker
For CTEs, is forcing inlining the example we want to give, rather than the example of forcing materialization given? According to the docs, virtual generated columns aren't yet supported. I'm pretty sure the docs are right. Do we still want to mention it? Otherwise it looks good to me. On Tue, M

Re: PostgreSQL 12 Beta 1 press release draft

2019-05-21 Thread Alexander Korotkov
Hi! On Wed, May 22, 2019 at 6:40 AM Jonathan S. Katz wrote: > Attached is a draft of the PG12 Beta 1 press release that is going out > this Thursday. The primary goals of this release announcement are to > introduce new features, enhancements, and changes that are available in > PG12, as well as

PostgreSQL 12 Beta 1 press release draft

2019-05-21 Thread Jonathan S. Katz
Hi, Attached is a draft of the PG12 Beta 1 press release that is going out this Thursday. The primary goals of this release announcement are to introduce new features, enhancements, and changes that are available in PG12, as well as encourage our users to test and provide feedback to help ensure t