On Wed, Aug 23, 2023 at 09:36:01AM -0700, Jeff Davis wrote:
> On Tue, 2023-08-22 at 22:23 -0400, Bruce Momjian wrote:
> > > I notice that this item is still listed:
> > >
> > > * Determine the ICU default locale from the environment (Jeff
> > > Davis)
> > >
> > > But that was reverted as part
On Tue, 2023-08-22 at 22:23 -0400, Bruce Momjian wrote:
> > I notice that this item is still listed:
> >
> > * Determine the ICU default locale from the environment (Jeff
> > Davis)
> >
> > But that was reverted as part of 2535c74b1a.
>
> The original commit is:
>
> Author: Jeff Davis
On Tue, Aug 22, 2023 at 01:42:41PM -0700, Jeff Davis wrote:
> On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote:
> > I have completed the first draft of the PG 16 release notes. You can
> > see the output here:
>
>
>
On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote:
> I have completed the first draft of the PG 16 release notes. You can
> see the output here:
https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-LOCALIZATION
I notice that this item is still listed:
* Determine the ICU
On Tue, Aug 22, 2023 at 10:02:16AM +0300, Pavel Luzanov wrote:
> On 22.08.2023 00:58, Bruce Momjian wrote:
> > Attached is an applied patch that moves the inherit item into
> > incompatibilities. clarifies it, and splits out the ADMIN syntax item.
>
> > The role's default inheritance behavior can
On 22.08.2023 00:58, Bruce Momjian wrote:
Attached is an applied patch that moves the inherit item into
incompatibilities. clarifies it, and splits out the ADMIN syntax item.
> The role's default inheritance behavior can be overridden with the
new GRANT ... WITH INHERIT clause.
The only
On Tue, 22 Aug 2023 at 10:08, Bruce Momjian wrote:
>
> On Sat, Aug 19, 2023 at 04:24:48AM +0200, Erwin Brandstetter wrote:
> > I posted to pgsql-docs first, but was kindly redirected here by Jonathan:
> >
> > The release notes for Postgres 16 says here:
> >
On Sat, Aug 19, 2023 at 04:24:48AM +0200, Erwin Brandstetter wrote:
> I posted to pgsql-docs first, but was kindly redirected here by Jonathan:
>
> The release notes for Postgres 16 says here:
> https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PERFORMANCE
>
> Same as here:
>
On Sat, Aug 19, 2023 at 12:59:47PM -0400, Bruce Momjian wrote:
> On Thu, Aug 17, 2023 at 08:37:28AM +0300, Pavel Luzanov wrote:
> > I can try to explain how I understand it myself.
> >
> > In v15 and early, inheritance of granted to role privileges depends on
> > INHERIT attribute of a role:
> >
On Thu, Aug 17, 2023 at 08:37:28AM +0300, Pavel Luzanov wrote:
> On 17.08.2023 05:36, Bruce Momjian wrote:
> > On Wed, Aug 9, 2023 at 08:35:21PM -0400, Bruce Momjian wrote:
> > > On Sat, Aug 5, 2023 at 04:08:47PM -0700, Noah Misch wrote:
> > > > > Author: Robert Haas
> > > > > 2022-08-25
I posted to pgsql-docs first, but was kindly redirected here by Jonathan:
The release notes for Postgres 16 says here:
https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PERFORMANCE
Same as here:
https://momjian.us/pgsql_docs/release-16.html#RELEASE-16-PERFORMANCE
Allow window
On Wed, Aug 16, 2023 at 10:36:05PM -0400, Bruce Momjian wrote:
> You can view the Postgres 16 release notes, with markup and links to our
> docs, here:
>
> https://momjian.us/pgsql_docs/release-16.html
FYI, thanks to this patch:
commit 78ee60ed84
Author: Tom Lane
On 17.08.2023 05:36, Bruce Momjian wrote:
On Wed, Aug 9, 2023 at 08:35:21PM -0400, Bruce Momjian wrote:
On Sat, Aug 5, 2023 at 04:08:47PM -0700, Noah Misch wrote:
Author: Robert Haas
2022-08-25 [e3ce2de09] Allow grant-level control of role inheritance behavior.
-->
Allow GRANT to control
On Wed, Aug 9, 2023 at 08:35:21PM -0400, Bruce Momjian wrote:
> On Sat, Aug 5, 2023 at 04:08:47PM -0700, Noah Misch wrote:
> > > Author: Robert Haas
> > > 2022-08-25 [e3ce2de09] Allow grant-level control of role inheritance
> > > behavior.
> > > -->
> > >
> > >
> > >
> > > Allow GRANT to
You can view the Postgres 16 release notes, with markup and links to our
docs, here:
https://momjian.us/pgsql_docs/release-16.html
--
Bruce Momjian https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important
On Thu, Aug 10, 2023 at 07:56:12AM +0300, Pavel Luzanov wrote:
> On 09.08.2023 21:06, Bruce Momjian wrote:
> > On Sun, Jul 23, 2023 at 02:09:17PM +0300, Pavel Luzanov wrote:
> > > Please consider to add item to the psql section:
> > >
> > > Add psql \drg command to display role grants and remove
On 09.08.2023 21:06, Bruce Momjian wrote:
On Sun, Jul 23, 2023 at 02:09:17PM +0300, Pavel Luzanov wrote:
Please consider to add item to the psql section:
Add psql \drg command to display role grants and remove the "Member of"
column from \du & \dg altogether (d65ddaca)
The release notes are
FYI, the current PG 16 release notes are available at:
https://momjian.us/pgsql_docs/release-16.html
I plan to add markup next week. I am sorry I was away most of July so
could not update this until now.
--
Bruce Momjian https://momjian.us
EDB
On Sat, Aug 5, 2023 at 04:08:47PM -0700, Noah Misch wrote:
> > Remove libpq support for SCM credential authentication (Michael Paquier)
>
> Since the point of removing it is the deep unlikelihood of anyone using it, I
> wouldn't list this in "incompatibilities".
I moved this to the Source Code
On Sat, Aug 5, 2023 at 04:08:47PM -0700, Noah Misch wrote:
> > Author: Robert Haas
> > 2022-08-25 [e3ce2de09] Allow grant-level control of role inheritance
> > behavior.
> > -->
> >
> >
> >
> > Allow GRANT to control role inheritance behavior (Robert Haas)
> >
> >
> >
> > By default, role
On Wed, Aug 09, 2023 at 05:45:27PM -0400, Bruce Momjian wrote:
> That is very helpful. I added this to the release notes Server
> Configuration section:
>
>
>
> Allow huge pages to work on newer versions of Windows 10 (Thomas Munro)
>
>
>
> This
On Sat, Aug 5, 2023 at 04:08:47PM -0700, Noah Misch wrote:
> On Thu, May 18, 2023 at 04:49:47PM -0400, Bruce Momjian wrote:
> > https://momjian.us/pgsql_docs/release-16.html
>
> >
> >
> >
> >
> > Restrict the privileges of CREATEROLE roles (Robert Haas)
> >
> >
> >
> > Previously
On Sun, Jul 23, 2023 at 08:19:55PM +0900, Michael Paquier wrote:
> On Tue, Jul 04, 2023 at 05:32:07PM -0400, Bruce Momjian wrote:
> > On Tue, Jul 4, 2023 at 03:31:05PM +0900, Michael Paquier wrote:
> >> On Thu, May 18, 2023 at 04:49:47PM -0400, Bruce Momjian wrote:
> >> Sawada-san has mentioned
On Sun, Jul 23, 2023 at 02:09:17PM +0300, Pavel Luzanov wrote:
> Please consider to add item to the psql section:
>
> Add psql \drg command to display role grants and remove the "Member of"
> column from \du & \dg altogether (d65ddaca)
The release notes are only current as of 2023-06-26 and I
On Sun, Jul 23, 2023 at 12:45:17PM +0800, jian he wrote:
> > https://momjian.us/pgsql_docs/release-16.html
> >
> > I will adjust it to the feedback I receive; that URL will quickly show
> > all updates.
>
> > Create a predefined role and grantable privilege with permission to
> >
On Fri, Jul 14, 2023 at 09:29:42PM +0200, Erik Rijkers wrote:
> Op 7/4/23 om 23:32 schreef Bruce Momjian:
> > > > https://momjian.us/pgsql_docs/release-16.html
>
> I noticed these:
>
> 'new new RULES' should be
> 'new RULES'
>
> 'Perform apply of large transactions' should be
>
On Fri, Jul 14, 2023 at 08:20:59PM +0200, Laurenz Albe wrote:
> On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote:
> > I have completed the first draft of the PG 16 release notes.
>
> The release notes still have:
>
> - Have initdb use ICU by default if ICU is enabled in the binary (Jeff
On Fri, Jul 14, 2023 at 08:16:38PM +0200, Laurenz Albe wrote:
> On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote:
> > I have completed the first draft of the PG 16 release notes.
>
> The release notes say:
>
> - Prevent \df+ from showing function source code (Isaac Morland)
>
> Function
On Thu, May 18, 2023 at 04:49:47PM -0400, Bruce Momjian wrote:
> https://momjian.us/pgsql_docs/release-16.html
>
>
>
>
> Restrict the privileges of CREATEROLE roles (Robert Haas)
>
>
>
> Previously roles with CREATEROLE privileges could change many aspects of any
> non-superuser
On Tue, Jul 04, 2023 at 05:32:07PM -0400, Bruce Momjian wrote:
> On Tue, Jul 4, 2023 at 03:31:05PM +0900, Michael Paquier wrote:
>> On Thu, May 18, 2023 at 04:49:47PM -0400, Bruce Momjian wrote:
>> Sawada-san has mentioned on twitter that fdd8937 is not mentioned in
>> the release notes, and it
Please consider to add item to the psql section:
Add psql \drg command to display role grants and remove the "Member of"
column from \du & \dg altogether (d65ddaca)
--
Pavel Luzanov
Postgres Professional: https://postgrespro.com
> https://momjian.us/pgsql_docs/release-16.html
>
> I will adjust it to the feedback I receive; that URL will quickly show
> all updates.
> Create a predefined role and grantable privilege with permission to perform
> maintenance operations (Nathan Bossart)
> The predefined role is is
Op 7/4/23 om 23:32 schreef Bruce Momjian:
https://momjian.us/pgsql_docs/release-16.html
I noticed these:
'new new RULES' should be
'new RULES'
'Perform apply of large transactions' should be
'Performs apply of large transactions'
(I think)
'SQL JSON paths' should be
'SQL/JSON
On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote:
> I have completed the first draft of the PG 16 release notes.
The release notes still have:
- Have initdb use ICU by default if ICU is enabled in the binary (Jeff Davis)
Option --locale-provider=libc can be used to disable ICU.
But
On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote:
> I have completed the first draft of the PG 16 release notes.
The release notes say:
- Prevent \df+ from showing function source code (Isaac Morland)
Function bodies are more easily viewed with \ev and \ef.
That should be \sf, not \ev
On Tue, Jul 4, 2023 at 03:31:05PM +0900, Michael Paquier wrote:
> On Thu, May 18, 2023 at 04:49:47PM -0400, Bruce Momjian wrote:
> > I have completed the first draft of the PG 16 release notes. You can
> > see the output here:
> >
> > https://momjian.us/pgsql_docs/release-16.html
> >
> > I
On Thu, May 18, 2023 at 04:49:47PM -0400, Bruce Momjian wrote:
> I have completed the first draft of the PG 16 release notes. You can
> see the output here:
>
> https://momjian.us/pgsql_docs/release-16.html
>
> I will adjust it to the feedback I receive; that URL will quickly show
> all
On Fri, Jun 30, 2023 at 05:29:17PM +0900, Masahiro Ikeda wrote:
> Hi,
>
> Thanks for making the release notes. I found the release note of
> PG16 beta2 mentions a reverted following feature.
>
> ```
>
>
>
>
> Have initdb use ICU by default if ICU is enabled in the binary (Jeff Davis)
>
>
>
Hi,
Thanks for making the release notes. I found the release note of
PG16 beta2 mentions a reverted following feature.
```
Have initdb use ICU by default if ICU is enabled in the binary (Jeff
Davis)
Option --locale-provider=libc can be used to disable ICU.
```
Unfortunately, the
On Tue, Jun 27, 2023 at 03:49:44PM -0600, Roberto Mello wrote:
> Adding to this thread as suggested by jkatz for consideration of
> adding to release notes...
>
> In [1] I mention the omission of ldap_password_hook and a suggested paragraph.
>
> Roberto
>
> [1]
>
Adding to this thread as suggested by jkatz for consideration of
adding to release notes...
In [1] I mention the omission of ldap_password_hook and a suggested paragraph.
Roberto
[1]
https://www.postgresql.org/message-id/CAKz%3D%3DbLzGb-9O294AoZHqEWpAi2Ki58yCr4gaqg1HnZyh3L1uA%40mail.gmail.com
On Thu, Jun 8, 2023 at 02:23:33PM +0900, Masahiko Sawada wrote:
> Hi,
>
> On Fri, May 19, 2023 at 5:49 AM Bruce Momjian wrote:
> >
> > I have completed the first draft of the PG 16 release notes. You can
> > see the output here:
> >
> > https://momjian.us/pgsql_docs/release-16.html
> >
On Mon, 5 Jun 2023 11:42:43 -0400
Bruce Momjian wrote:
> On Mon, Jun 5, 2023 at 05:33:51PM +0900, Yugo NAGATA wrote:
> > Hello,
> >
> > On Thu, 18 May 2023 16:49:47 -0400
> > Bruce Momjian wrote:
> >
> > > I have completed the first draft of the PG 16 release notes. You can
> > > see the
Hi,
On Fri, May 19, 2023 at 5:49 AM Bruce Momjian wrote:
>
> I have completed the first draft of the PG 16 release notes. You can
> see the output here:
>
> https://momjian.us/pgsql_docs/release-16.html
>
> I will adjust it to the feedback I receive; that URL will quickly show
> all
On Mon, Jun 5, 2023 at 05:33:51PM +0900, Yugo NAGATA wrote:
> Hello,
>
> On Thu, 18 May 2023 16:49:47 -0400
> Bruce Momjian wrote:
>
> > I have completed the first draft of the PG 16 release notes. You can
> > see the output here:
>
> Thanks for the release notes.
>
> >
> >
Hello,
On Thu, 18 May 2023 16:49:47 -0400
Bruce Momjian wrote:
> I have completed the first draft of the PG 16 release notes. You can
> see the output here:
Thanks for the release notes.
>
> https://momjian.us/pgsql_docs/release-16.html
>
> I will adjust it to the feedback I receive;
On Wed, May 31, 2023 at 06:03:01PM +1200, David Rowley wrote:
> I don't think this should go under "E.1.3.11. Source Code". The patch
> was entirely aimed to increase performance, not just of allocations
> themselves, but of any operations which uses palloc'd memory. This is
> due to the patch
On Wed, 31 May 2023 at 11:32, Bruce Momjian wrote:
>
> On Thu, May 25, 2023 at 05:57:25PM +1200, David Rowley wrote:
> > On 64-bit builds, it was 16 bytes for AllocSet contexts, 24 bytes for
> > generation contexts and 16 bytes for slab contexts.
>
> Okay, item added to Source Code:
I don't
On Thu, May 25, 2023 at 05:57:25PM +1200, David Rowley wrote:
> On Thu, 25 May 2023 at 05:45, Bruce Momjian wrote:
> >
> > On Wed, May 24, 2023 at 01:43:50PM -0400, Bruce Momjian wrote:
> > > > * Reduce palloc() memory overhead for all memory allocations down to 8
> > > > bytes on all platforms.
On Tue, May 30, 2023 at 06:33:09AM -0400, Masahiko Sawada wrote:
> Hi,
>
> On Thu, May 18, 2023 at 4:49 PM Bruce Momjian wrote:
> >
> > I have completed the first draft of the PG 16 release notes. You can
> > see the output here:
> >
>
> I have one suggestion on this item:
>
>
>
>
>
>
Hi,
On Thu, May 18, 2023 at 4:49 PM Bruce Momjian wrote:
>
> I have completed the first draft of the PG 16 release notes. You can
> see the output here:
>
I have one suggestion on this item:
Allow logical replication subscribers to process only changes that
have no origin (Vignesh C, Amit
Bruce Momjian writes:
> On Sat, May 27, 2023 at 09:34:37PM -0400, Bruce Momjian wrote:
>> > > This is controlled by auto_explain.log_parameter_max_length, and by
>> > > default query parameters will be logged with no length
>> > > restriction. SHOULD THIS BE MORE CLEARLY IDENTIFIED AS
On Sat, May 27, 2023 at 09:34:37PM -0400, Bruce Momjian wrote:
> > > This is controlled by auto_explain.log_parameter_max_length, and by
> > > default query parameters will be logged with no length
> > > restriction. SHOULD THIS BE MORE CLEARLY IDENTIFIED AS CONTROLLING THE
> > > EXECUTION OF
On Wed, May 24, 2023 at 04:13:14PM +1200, David Rowley wrote:
> On Wed, 24 May 2023 at 15:54, Bruce Momjian wrote:
> > First, I need to mention parallel _hash_ join. Second, I think this
> > item is saying that the _inner_ side of a parallel hash join can be an
> > OUTER or FULL join. How
On Tue, May 23, 2023 at 11:54:30PM -0400, Bruce Momjian wrote:
> On Wed, May 24, 2023 at 08:37:45AM +1200, David Rowley wrote:
> > On Mon, 22 May 2023 at 07:05, Jonathan S. Katz wrote:
> > > * Parallel execution of queries that use `FULL` and `OUTER` joins
> >
> > I think this should be `RIGHT`
On Mon, May 29, 2023 at 10:08:41AM -0400, Masahiko Sawada wrote:
> On Sun, May 21, 2023 at 10:47 PM Bruce Momjian wrote:
> >
> > Okay new merged item is:
> >
> >
> >
> >
> >
> > Allow logical decoding on standbys (Bertrand Drouvot, Andres
> > Freund, Amit
On Sun, May 21, 2023 at 10:47 PM Bruce Momjian wrote:
>
> Okay new merged item is:
>
>
>
>
>
> Allow logical decoding on standbys (Bertrand Drouvot, Andres Freund,
> Amit Khandekar, Bertrand Drouvot)
>
>
>
>
>
> New
On Fri, May 26, 2023 at 12:21:23PM +0200, Álvaro Herrera wrote:
> On 2023-May-25, Laurenz Albe wrote:
>
> > @@ -1335,7 +1335,7 @@ Author: Peter Eisentraut
> >
> >
> >
> > -Add Windows process the system collations (Jose Santamaria Flecha)
> > +Add Windows to process the system collations
On Thu, May 25, 2023 at 11:51:24PM +0200, Laurenz Albe wrote:
> On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote:
> > I have completed the first draft of the PG 16 release notes.
>
> I found two typos.
> diff --git a/doc/src/sgml/release-16.sgml b/doc/src/sgml/release-16.sgml
> index
On Thu, May 25, 2023 at 09:20:11PM +0100, Dagfinn Ilmari Mannsåker wrote:
> Bruce Momjian writes:
>
> > I have completed the first draft of the PG 16 release notes. You can
> > see the output here:
> >
> > https://momjian.us/pgsql_docs/release-16.html
> >
> > I will adjust it to the
On 2023-May-25, Laurenz Albe wrote:
> @@ -1335,7 +1335,7 @@ Author: Peter Eisentraut
>
>
>
> -Add Windows process the system collations (Jose Santamaria Flecha)
> +Add Windows to process the system collations (Jose Santamaria Flecha)
> ADD THIS?
>
>
Hmm, not sure this describes the
On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote:
> I have completed the first draft of the PG 16 release notes.
I found two typos.
Yours,
Laurenz Albe
diff --git a/doc/src/sgml/release-16.sgml b/doc/src/sgml/release-16.sgml
index faecae7c42..7dad0b8550 100644
---
Bruce Momjian writes:
> I have completed the first draft of the PG 16 release notes. You can
> see the output here:
>
> https://momjian.us/pgsql_docs/release-16.html
>
> I will adjust it to the feedback I receive; that URL will quickly show
> all updates.
The bit about auto_explain and
On Thu, 25 May 2023 at 05:45, Bruce Momjian wrote:
>
> On Wed, May 24, 2023 at 01:43:50PM -0400, Bruce Momjian wrote:
> > > * Reduce palloc() memory overhead for all memory allocations down to 8
> > > bytes on all platforms. (Andres Freund, David Rowley)
> > >
> > > This allows more efficient use
On Thu, May 25, 2023 at 08:31:29AM +0700, John Naylor wrote:
>
> On Wed, May 24, 2023 at 8:58 PM Bruce Momjian wrote:
> >
> > Okay, items split into sections and several merged. I left the
> > CPU-specific parts in Source Code, and moved the rest into a merged item
> > in General Performance,
On Wed, May 24, 2023 at 8:58 PM Bruce Momjian wrote:
>
> Okay, items split into sections and several merged. I left the
> CPU-specific parts in Source Code, and moved the rest into a merged item
> in General Performance, but moved the JSON item to Data Types.
It looks like it got moved to
On Wed, May 24, 2023 at 01:43:50PM -0400, Bruce Momjian wrote:
> > * Reduce palloc() memory overhead for all memory allocations down to 8
> > bytes on all platforms. (Andres Freund, David Rowley)
> >
> > This allows more efficient use of memory and is especially useful in
> > queries which
On Wed, May 24, 2023 at 08:48:56AM +1200, David Rowley wrote:
> On Tue, 23 May 2023 at 06:04, Bruce Momjian wrote:
> >
> > On Mon, May 22, 2023 at 10:59:36AM -0700, Andres Freund wrote:
> > > And here it's not just performance, but also memory usage, including
> > > steady
> > > state memory
On 5/24/23 12:13 AM, David Rowley wrote:
On Wed, 24 May 2023 at 15:54, Bruce Momjian wrote:
On Wed, May 24, 2023 at 08:37:45AM +1200, David Rowley wrote:
On Mon, 22 May 2023 at 07:05, Jonathan S. Katz wrote:
* Parallel execution of queries that use `FULL` and `OUTER` joins
I think this
On Wed, May 24, 2023 at 04:57:59PM +0200, Erik Rijkers wrote:
> Op 5/24/23 om 15:58 schreef Bruce Momjian:
> > On Wed, May 24, 2023 at 12:23:02PM +0700, John Naylor wrote:
> > >
> > > On Wed, May 24, 2023 at 11:19 AM Bruce Momjian wrote:
>
> Typos:
>
> 'from standbys servers' should be
>
Op 5/24/23 om 15:58 schreef Bruce Momjian:
On Wed, May 24, 2023 at 12:23:02PM +0700, John Naylor wrote:
On Wed, May 24, 2023 at 11:19 AM Bruce Momjian wrote:
Typos:
'from standbys servers' should be
'from standby servers'
'reindexedb' should be
'reindexdb'
(2x: the next line mentions,
On Wed, May 24, 2023 at 12:23:02PM +0700, John Naylor wrote:
>
> On Wed, May 24, 2023 at 11:19 AM Bruce Momjian wrote:
> >
> > Second, you might be correct that the section is wrong. I thought of
> > CPU instructions as something tied to the compiler, so part of the build
> > process or source
On Wed, May 24, 2023 at 11:19 AM Bruce Momjian wrote:
>
> Second, you might be correct that the section is wrong. I thought of
> CPU instructions as something tied to the compiler, so part of the build
> process or source code, but the point we should be make is that we have
> these
On Tue, May 23, 2023 at 12:14:04PM +0700, John Naylor wrote:
> On Tue, May 23, 2023 at 11:26 AM Bruce Momjian wrote:
> >
> > On Tue, May 23, 2023 at 09:58:30AM +0700, John Naylor wrote:
> > > > Allow ASCII string detection to use vector operations on x86-64
> architectures
> > > (John Naylor)
> >
On Wed, 24 May 2023 at 15:54, Bruce Momjian wrote:
>
> On Wed, May 24, 2023 at 08:37:45AM +1200, David Rowley wrote:
> > On Mon, 22 May 2023 at 07:05, Jonathan S. Katz wrote:
> > > * Parallel execution of queries that use `FULL` and `OUTER` joins
> >
> > I think this should be `RIGHT` joins
On Tue, May 23, 2023 at 12:14:04PM +0700, John Naylor wrote:
> On Tue, May 23, 2023 at 11:26 AM Bruce Momjian wrote:
> > > > Allow xid/subxid searches to use vector operations on x86-64
> architectures
> > > (Nathan Bossart)
> > >
> > > When moved to the performance section, it would be something
On Tue, May 23, 2023 at 06:27:23PM -0400, Jonathan Katz wrote:
> On 5/23/23 4:37 PM, David Rowley wrote:
> > On Mon, 22 May 2023 at 07:05, Jonathan S. Katz wrote:
> > > * Parallel execution of queries that use `FULL` and `OUTER` joins
> >
> > I think this should be `RIGHT` joins rather than
On Wed, May 24, 2023 at 08:37:45AM +1200, David Rowley wrote:
> On Mon, 22 May 2023 at 07:05, Jonathan S. Katz wrote:
> > * Parallel execution of queries that use `FULL` and `OUTER` joins
>
> I think this should be `RIGHT` joins rather than `OUTER` joins.
>
> LEFT joins have been parallelizable
On 5/22/23 4:18 PM, Robert Haas wrote:
On Sun, May 21, 2023 at 3:05 PM Jonathan S. Katz wrote:
* Support for regular expressions for matching usernames and databases
names in `pg_hba.conf`, and user names in `pg_ident.conf`
I suggest that this is not a major feature.
Perhaps the work that I
On 5/23/23 4:37 PM, David Rowley wrote:
On Mon, 22 May 2023 at 07:05, Jonathan S. Katz wrote:
* Parallel execution of queries that use `FULL` and `OUTER` joins
I think this should be `RIGHT` joins rather than `OUTER` joins.
LEFT joins have been parallelizable I think for a long time now.
On Tue, 23 May 2023 at 06:04, Bruce Momjian wrote:
>
> On Mon, May 22, 2023 at 10:59:36AM -0700, Andres Freund wrote:
> > And here it's not just performance, but also memory usage, including steady
> > state memory usage.
>
> Understood. I continue to need help determining which items to
On Mon, 22 May 2023 at 07:05, Jonathan S. Katz wrote:
> * Parallel execution of queries that use `FULL` and `OUTER` joins
I think this should be `RIGHT` joins rather than `OUTER` joins.
LEFT joins have been parallelizable I think for a long time now.
David
On Tue, May 23, 2023 at 11:26 AM Bruce Momjian wrote:
>
> On Tue, May 23, 2023 at 09:58:30AM +0700, John Naylor wrote:
> > > Allow ASCII string detection to use vector operations on x86-64
architectures
> > (John Naylor)
> > > Allow JSON string processing to use vector operations on x86-64
On Tue, May 23, 2023 at 09:58:30AM +0700, John Naylor wrote:
> Hi Bruce,
>
> > Add support for SSE2 (Streaming SIMD Extensions 2) vector operations on
> x86-64 architectures (John Naylor)
>
> > Add support for Advanced SIMD (Single Instruction Multiple Data) (NEON)
> instructions on ARM
Hi Bruce,
> Add support for SSE2 (Streaming SIMD Extensions 2) vector operations on
x86-64 architectures (John Naylor)
> Add support for Advanced SIMD (Single Instruction Multiple Data) (NEON)
instructions on ARM architectures (Nathan Bossart)
Nit: It's a bit odd that SIMD is spelled out in
On Sun, May 21, 2023 at 3:05 PM Jonathan S. Katz wrote:
> * Support for regular expressions for matching usernames and databases
> names in `pg_hba.conf`, and user names in `pg_ident.conf`
I suggest that this is not a major feature.
Perhaps the work that I did to improve CREATEROLE could be
On Mon, May 22, 2023 at 11:03:31AM -0700, Andres Freund wrote:
> On 2023-05-21 22:52:09 -0400, Bruce Momjian wrote:
> > Do average users know heap and index files are both relations? That
> > seems too abstract so I spelled out heap and index pages.
>
> I don't know about average users - but I
On Mon, May 22, 2023 at 10:59:36AM -0700, Andres Freund wrote:
> On 2023-05-21 22:46:58 -0400, Bruce Momjian wrote:
> > > For the above two items, I mention items that would change user
> > > like new features or changes that are significant enough that they would
> > > change user behavior. For
Hi,
On 2023-05-21 22:52:09 -0400, Bruce Momjian wrote:
> On Sun, May 21, 2023 at 10:13:41AM -0700, Andres Freund wrote:
> > Hi,
> >
> > Thanks for the release notes!
> >
> > >
> > >
> > >
> > >
> > > Allow more efficient addition of multiple heap and index pages (Andres
> > > Freund)
> > >
I have added the major features to the release notes with the attached
patch.
---
On Sun, May 21, 2023 at 07:53:38PM -0400, Jonathan Katz wrote:
> On 5/21/23 3:04 PM, Jonathan S. Katz wrote:
> > On 5/18/23 4:49 PM, Bruce
Hi,
On 2023-05-21 22:46:58 -0400, Bruce Momjian wrote:
> > Looking through the release notes, I didn't see an entry for
> >
> > commit c6e0fe1f2a08505544c410f613839664eea9eb21
> > Author: David Rowley
> > Date: 2022-08-29 17:15:00 +1200
> >
> > Improve performance of and reduce overheads
On Sun, May 21, 2023 at 10:13:41AM -0700, Andres Freund wrote:
> Hi,
>
> Thanks for the release notes!
>
> >
> >
> >
> >
> > Allow more efficient addition of multiple heap and index pages (Andres
> > Freund)
> >
> >
>
> While the case of extending by multiple pages improved the most,
On Mon, May 22, 2023 at 09:03:11AM +0800, jian he wrote:
> In E.1.2. Migration to Version 16, probably need mention, some
> privilege command cannot restore.
> if new cluster bootstrap superuser name is not the same as old one. "GRANT x
> TO
> y GRANTED BY no_bootstrap_superuser; " will have
On Sun, May 21, 2023 at 10:13:41AM -0700, Andres Freund wrote:
> Hi,
>
> Thanks for the release notes!
>
> >
> >
> >
> >
> > Allow more efficient addition of multiple heap and index pages (Andres
> > Freund)
> >
> >
>
> While the case of extending by multiple pages improved the most,
In E.1.2. Migration to Version 16, probably need mention, some
privilege command cannot restore.
if new cluster bootstrap superuser name is not the same as old one. "GRANT
x TO y GRANTED BY no_bootstrap_superuser; " will have error.
---pg15 dump content.
CREATE ROLE jian;
ALTER ROLE jian WITH
On 5/21/23 3:04 PM, Jonathan S. Katz wrote:
On 5/18/23 4:49 PM, Bruce Momjian wrote:
I have completed the first draft of the PG 16 release notes.
One thing that we could attempt for this beta is to include a
prospective list of "major features + enhancements." Of course it can
change before
On 5/21/23 3:24 PM, Andres Freund wrote:
Hi,
On May 21, 2023 11:46:56 AM PDT, "Jonathan S. Katz"
wrote:
On 5/21/23 1:13 PM, Andres Freund wrote:
Looking through the release notes, I didn't see an entry for
commit c6e0fe1f2a08505544c410f613839664eea9eb21
Author: David Rowley
Date:
On Sun, May 21, 2023 at 01:11:05PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > On Sun, May 21, 2023 at 09:30:01PM +0900, Ian Lawrence Barwick wrote:
> >> 2ceea5adb Accept "+infinity" in date and timestamp[tz] input.
>
> > I have this but didn't add that commit, added.
>
> That's really
Hi,
On May 21, 2023 11:46:56 AM PDT, "Jonathan S. Katz"
wrote:
>On 5/21/23 1:13 PM, Andres Freund wrote:
>
>>
>> Looking through the release notes, I didn't see an entry for
>>
>> commit c6e0fe1f2a08505544c410f613839664eea9eb21
>> Author: David Rowley
>> Date: 2022-08-29 17:15:00 +1200
>>
On 5/18/23 4:49 PM, Bruce Momjian wrote:
I have completed the first draft of the PG 16 release notes.
One thing that we could attempt for this beta is to include a
prospective list of "major features + enhancements." Of course it can
change before the GA, but it'll give readers some idea of
1 - 100 of 141 matches
Mail list logo
