On Mon, 10 May 2021 02:03:08 -0400
Bruce Momjian wrote:
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
>
> I need clarification on many items, and the document still need
On Sat, Sep 18, 2021 at 05:15:39PM -0400, Tom Lane wrote:
> Justin Pryzby writes:
> > I think the release notes for the autovacuum item (which was first reverted
> > and
> > then partially un-reverted) should say something like "Partitioned tables
> > are
> > now included in pg_stat_all_tables":
Justin Pryzby writes:
> I think the release notes for the autovacuum item (which was first reverted
> and
> then partially un-reverted) should say something like "Partitioned tables are
> now included in pg_stat_all_tables":
> | e1efc5b465 Keep stats up to date for partitioned tables
Hmm. If I'
I think the release notes for the autovacuum item (which was first reverted and
then partially un-reverted) should say something like "Partitioned tables are
now included in pg_stat_all_tables":
| e1efc5b465 Keep stats up to date for partitioned tables
Remove some internal question/marks:
ACCURATE
On Fri, Jul 2, 2021 at 12:50 AM Bruce Momjian wrote:
>
> On Thu, Jul 1, 2021 at 03:13:30PM +0100, Simon Riggs wrote:
> > On Wed, Jun 30, 2021 at 11:20 PM Bruce Momjian wrote:
> > > > * "row expiration" is a term not currently used in PG docs, so we
> > > > should probably look for something else
On Mon, Jun 28, 2021 at 09:25:47PM -0500, Justin Pryzby wrote:
> On Mon, Jun 28, 2021 at 09:01:40PM -0400, Bruce Momjian wrote:
> > so we are talking about scans in parallel, so I think it is plural. Wrong?
>
> I think the "type" of scan being referenced is a "parallel" type, right ?
> So there's
On Thu, Jul 1, 2021 at 03:13:30PM +0100, Simon Riggs wrote:
> On Wed, Jun 30, 2021 at 11:20 PM Bruce Momjian wrote:
> > > * "row expiration" is a term not currently used in PG docs, so we
> > > should probably look for something else.
> >
> > Yeah, I changed that to "removing dead rows" which see
On Wed, Jun 30, 2021 at 11:20 PM Bruce Momjian wrote:
>
> On Tue, Jun 29, 2021 at 07:36:47PM +0100, Simon Riggs wrote:
> > Perhaps we should also add this text from the commit message to ensure
> > the importance is understood:
> > "This is extremely useful in cases where CIC/RC can run for a very
On Tue, Jun 29, 2021 at 07:36:47PM +0100, Simon Riggs wrote:
> Perhaps we should also add this text from the commit message to ensure
> the importance is understood:
> "This is extremely useful in cases where CIC/RC can run for a very long
> time, because that used to be a significant headache
On Fri, Jun 25, 2021 at 2:56 AM Bruce Momjian wrote:
>
> On Wed, Jun 23, 2021 at 07:45:53AM -0700, Peter Geoghegan wrote:
> > On Wed, Jun 23, 2021 at 5:50 AM Simon Riggs
> > wrote:
> > > I just noticed that these commits are missing, yet are very important
> > > new features:
> > > d9d076222f5b94
On Mon, Jun 28, 2021 at 09:01:40PM -0400, Bruce Momjian wrote:
> On Fri, Jun 25, 2021 at 06:04:56PM -0500, Justin Pryzby wrote:
> > > The postgres_fdw supports these type of scans if async_capable is set.
> > this type
> > remove "The" ?
>
> New text is:
>
> linkend="postgres-fdw">po
On Fri, Jun 25, 2021 at 06:04:56PM -0500, Justin Pryzby wrote:
> > Require custom server variable names to use only character which are valid
> > for unquoted SQL identifiers (Tom Lane)
>
> characters plural (since 69a58bfe4)
Fixed.
> > This is similar to how Unicode can be specified in literal
> Require custom server variable names to use only character which are valid
> for unquoted SQL identifiers (Tom Lane)
characters plural (since 69a58bfe4)
> This is similar to how Unicode can be specified in literal string.
literal strings
> Add executor method to cache results from the inner-
On Wed, Jun 23, 2021 at 07:45:53AM -0700, Peter Geoghegan wrote:
> On Wed, Jun 23, 2021 at 5:50 AM Simon Riggs
> wrote:
> > I just noticed that these commits are missing, yet are very important
> > new features:
> > d9d076222f5b94a8
> > f9900df5f9
> > c98763bf51bf
> >
> > These are important enoug
On Wed, Jun 23, 2021 at 5:50 AM Simon Riggs
wrote:
> I just noticed that these commits are missing, yet are very important
> new features:
> d9d076222f5b94a8
> f9900df5f9
> c98763bf51bf
>
> These are important enough to be major features of PG14.
I certainly think that they're important enough to
On Mon, May 10, 2021 at 7:03 AM Bruce Momjian wrote:
>
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
>
> I need clarification on many items, and the document still needs
On Mon, Jun 21, 2021 at 02:47:16PM +0900, Tatsuo Ishii wrote:
> > I got the parse error after applying the patch:
> >
> > release-14.sgml:3562: parser error : Input is not proper UTF-8,
> > indicate encoding !
> > Bytes: 0xE9 0x20 0x53 0x61
> > (Juan Jos Santamara Flecha)
> >
> On Mon, Jun 21, 2021 at 12:50 PM Bruce Momjian wrote:
>>
>> On Tue, Jun 15, 2021 at 12:01:00PM +0900, Michael Paquier wrote:
>> > On Tue, Jun 15, 2021 at 11:49:21AM +0900, Masahiko Sawada wrote:
>> > > On Tue, Jun 15, 2021 at 10:36 AM Bruce Momjian wrote:
>> > >> OK, but I need more information
On Mon, Jun 21, 2021 at 2:07 PM Bruce Momjian wrote:
>
> On Mon, Jun 21, 2021 at 01:57:32PM +0900, Masahiko Sawada wrote:
> > > OK, I went with this text and put it in the Source Code section since it
> > > applies to several layers of Postgres.
> >
> > Thanks!
> >
> > I got the parse error after
On Fri, Jun 18, 2021 at 08:47:21PM -0700, Peter Geoghegan wrote:
> On Mon, Jun 14, 2021 at 1:11 PM Bruce Momjian wrote:
> > FYI, the most recent PG 14 relnote doc build is at:
> >
> > https://momjian.us/pgsql_docs/release-14.html
>
> I just pushed a commit that makes the existing vacuum_i
On Mon, Jun 21, 2021 at 01:57:32PM +0900, Masahiko Sawada wrote:
> > OK, I went with this text and put it in the Source Code section since it
> > applies to several layers of Postgres.
>
> Thanks!
>
> I got the parse error after applying the patch:
>
> release-14.sgml:3562: parser error : Input
On Mon, Jun 21, 2021 at 12:50 PM Bruce Momjian wrote:
>
> On Tue, Jun 15, 2021 at 12:01:00PM +0900, Michael Paquier wrote:
> > On Tue, Jun 15, 2021 at 11:49:21AM +0900, Masahiko Sawada wrote:
> > > On Tue, Jun 15, 2021 at 10:36 AM Bruce Momjian wrote:
> > >> OK, but I need more information on how
On Tue, Jun 15, 2021 at 12:01:00PM +0900, Michael Paquier wrote:
> On Tue, Jun 15, 2021 at 11:49:21AM +0900, Masahiko Sawada wrote:
> > On Tue, Jun 15, 2021 at 10:36 AM Bruce Momjian wrote:
> >> OK, but I need more information on how users will see a difference based
> >> on this commit:
>
> +1.
On Mon, Jun 14, 2021 at 1:11 PM Bruce Momjian wrote:
> FYI, the most recent PG 14 relnote doc build is at:
>
> https://momjian.us/pgsql_docs/release-14.html
I just pushed a commit that makes the existing vacuum_index_cleanup
reloption and INDEX_CLEANUP VACUUM parameter support disabling t
On Tue, Jun 15, 2021 at 11:49:21AM +0900, Masahiko Sawada wrote:
> On Tue, Jun 15, 2021 at 10:36 AM Bruce Momjian wrote:
>> OK, but I need more information on how users will see a difference based
>> on this commit:
+1. That would be good to have in the release notes.
> I think that since with
On Tue, Jun 15, 2021 at 10:36 AM Bruce Momjian wrote:
>
> On Tue, Jun 15, 2021 at 10:06:49AM +0900, Masahiko Sawada wrote:
> > On Mon, May 10, 2021 at 3:03 PM Bruce Momjian wrote:
> > >
> > > I have committed the first draft of the PG 14 release notes. You can
> > > see the most current build o
On Tue, Jun 15, 2021 at 10:06:49AM +0900, Masahiko Sawada wrote:
> On Mon, May 10, 2021 at 3:03 PM Bruce Momjian wrote:
> >
> > I have committed the first draft of the PG 14 release notes. You can
> > see the most current build of them here:
> >
> > https://momjian.us/pgsql_docs/release-
On Mon, May 10, 2021 at 3:03 PM Bruce Momjian wrote:
>
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
>
It might have already been discussed but I think we should mention
On Mon, Jun 14, 2021 at 01:29:42PM -0400, John Naylor wrote:
> Hi Bruce,
>
> For this item:
>
>
>
>
> Allow BRIN indexes to use bloom filters
> (Tomas Vondra)
>
>
>
> This allows bloom indexes to be used effectively with data that
> is no
On Mon, Jun 14, 2021 at 06:57:41PM +0200, Tomas Vondra wrote:
> Sorry it took me a while to look at the release notes. I have one
> suggestion regarding this item:
>
>
> Allow logical replication to stream long in-progress transactions to
> subscribers (Tomas Vondra, Dilip Kumar, Amit Kapila,
On Mon, Jun 14, 2021 at 11:37:58AM -0500, Justin Pryzby wrote:
> Some more:
>
> | VACUUM now has a PROCESS_TOAST which can be set to false to disable TOAST
> processing, and vacuumdb has a --no-process-toast option.
> has a process_toast *option
Agreed.
> | Previously, if the object already ex
On Fri, Jun 11, 2021 at 10:45:51PM -0500, Justin Pryzby wrote:
> | Add Set Server Name Indication (SNI) for SSL connection packets (Peter
> Eisentraut)
> Remove "Set"
Fixed.
> | Reduce the default value of vacuum_cost_page_miss from 10 milliseconds to 2
> (Peter Geoghegan)
> Peter mentioned t
Hi Bruce,
For this item:
Allow BRIN indexes to use bloom filters
(Tomas Vondra)
This allows bloom indexes to be used effectively with data that
is not physically localized in the heap.
The text implies that this affects co
On 5/10/21 8:03 AM, Bruce Momjian wrote:
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
>
> I need clarification on many items, and the document still needs its
> items pro
On Fri, Jun 11, 2021 at 10:45:51PM -0500, Justin Pryzby wrote:
> | Add Set Server Name Indication (SNI) for SSL connection packets (Peter
> Eisentraut)
> Remove "Set"
>
> | Reduce the default value of vacuum_cost_page_miss from 10 milliseconds to 2
> (Peter Geoghegan)
> Peter mentioned that th
| Add Set Server Name Indication (SNI) for SSL connection packets (Peter
Eisentraut)
Remove "Set"
| Reduce the default value of vacuum_cost_page_miss from 10 milliseconds to 2
(Peter Geoghegan)
Peter mentioned that this should not say "milliseconds" (but maybe the page I'm
looking at is old).
On Fri, Jun 4, 2021 at 04:31:06PM -0500, Justin Pryzby wrote:
> doc/src/sgml/release-14.sgml-
> doc/src/sgml/release-14.sgml-
> doc/src/sgml/release-14.sgml-
> doc/src/sgml/release-14.sgml-
> doc/src/sgml/release-14.sgml-Add system view doc/src/sgml/release-14.sgml-
>
doc/src/sgml/release-14.sgml-
doc/src/sgml/release-14.sgml-
doc/src/sgml/release-14.sgml-
doc/src/sgml/release-14.sgml-
doc/src/sgml/release-14.sgml-Add system view pg_stat_wal
doc/src/sgml/release-14.sgml-which reports WAL
activity (Masahiro Ikeda)
doc/src/sgml/releas
On Sat, May 22, 2021 at 07:29:45PM -0400, Stephen Frost wrote:
> Greetings,
>
> * Bruce Momjian (br...@momjian.us) wrote:
> > I have committed the first draft of the PG 14 release notes. You can
> > see the most current build of them here:
> >
> > https://momjian.us/pgsql_docs/release-14.ht
Greetings,
* Bruce Momjian (br...@momjian.us) wrote:
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
It occurs to me that the wording around the new default roles could
pro
On Sat, May 22, 2021 at 03:35:13PM -0700, Peter Geoghegan wrote:
> On Thu, May 20, 2021 at 4:54 PM Bruce Momjian wrote:
> > I think our text "This new default better reflects current hardware
> > capabilities." is detailed enough. People can dig into the item to see
> > what it does and how it ad
On Thu, May 20, 2021 at 4:54 PM Bruce Momjian wrote:
> I think our text "This new default better reflects current hardware
> capabilities." is detailed enough. People can dig into the item to see
> what it does and how it adjusts costs.
Fair enough.
I noticed something about the same item that
On Thu, May 20, 2021 at 04:19:50PM -0700, Peter Geoghegan wrote:
> On Thu, May 20, 2021 at 2:37 PM Bruce Momjian wrote:
> > I went with this text:
> >
> > Reduce the default value of > linkend="guc-vacuum-cost-page-miss"> from 10 milliseconds
> > to 2
> > (Peter Geoghegan
On Thu, May 20, 2021 at 2:37 PM Bruce Momjian wrote:
> I went with this text:
>
> Reduce the default value of linkend="guc-vacuum-cost-page-miss"> from 10 milliseconds
> to 2
> (Peter Geoghegan)
>
> I think with numbers, and the fact we are saying "decrease" havint them
>
On Thu, May 20, 2021 at 04:35:07PM -0400, Álvaro Herrera wrote:
> On 2021-May-20, Bruce Momjian wrote:
>
> > On Thu, May 20, 2021 at 02:55:18PM -0500, Justin Pryzby wrote:
> > > On Thu, May 20, 2021 at 03:44:46PM -0400, Bruce Momjian wrote:
> > > > > | Reduce the default value of vacuum_cost_page_
On 2021-May-20, Bruce Momjian wrote:
> On Thu, May 20, 2021 at 02:55:18PM -0500, Justin Pryzby wrote:
> > On Thu, May 20, 2021 at 03:44:46PM -0400, Bruce Momjian wrote:
> > > > | Reduce the default value of vacuum_cost_page_miss (Peter Geoghegan)
> > > > | This new default better reflects curren
On Thu, May 20, 2021 at 02:55:18PM -0500, Justin Pryzby wrote:
> On Thu, May 20, 2021 at 03:44:46PM -0400, Bruce Momjian wrote:
> > > | Reduce the default value of vacuum_cost_page_miss (Peter Geoghegan)
> > > | This new default better reflects current hardware capabilities.
> > > Also say: the
On Thu, May 20, 2021 at 03:44:46PM -0400, Bruce Momjian wrote:
> > | Reduce the default value of vacuum_cost_page_miss (Peter Geoghegan)
> > | This new default better reflects current hardware capabilities.
> > Also say: the previous default was 10.
>
> Uh, we didn't report the new value, so wh
On Wed, May 19, 2021 at 09:39:08AM -0500, Justin Pryzby wrote:
> These sound weird since markup was added in 6a5bde7d4:
> https://www.postgresql.org/docs/devel/release-14.html
> | Remove server and Chapter 34 support for the version 2 wire protocol
> (Heikki Linnakangas)
> ...
> | Pass doubled quo
These sound weird since markup was added in 6a5bde7d4:
https://www.postgresql.org/docs/devel/release-14.html
| Remove server and Chapter 34 support for the version 2 wire protocol (Heikki
Linnakangas)
...
| Pass doubled quote marks in Chapter 36 SQL command strings literally (Tom
Lane)
-Remove s
On Tue, May 18, 2021 at 12:17 PM Bruce Momjian wrote:
> I went with this release note text:
That seems reasonable -- thanks!
--
Peter Geoghegan
On Tue, May 18, 2021 at 09:01:44AM -0700, Peter Geoghegan wrote:
> We do retain the reloption, but ignore it. Purely to avoid the dump and reload
> hazard. I think that you could reasonably tell users that it's gone
> completely,
> because it does nothing on either 13 or 14. It's hidden from them
We do retain the reloption, but ignore it. Purely to avoid the dump and
reload hazard. I think that you could reasonably tell users that it's gone
completely, because it does nothing on either 13 or 14. It's hidden from
them to the extent that that's possible.
Peter Geoghegan
(Sent from my phone)
On Tue, May 18, 2021 at 08:54:56AM -0700, Peter Geoghegan wrote:
> On Tue, May 18, 2021 at 8:48 AM Bruce Momjian wrote:
> > I am thiking the vacuum_cleanup_index_scale_factor existance in a PG 14
> > postgresql.conf will throw an error, unlike 13.x, so I do think we need
> > to mention this so peo
On Tue, May 18, 2021 at 8:48 AM Bruce Momjian wrote:
> I am thiking the vacuum_cleanup_index_scale_factor existance in a PG 14
> postgresql.conf will throw an error, unlike 13.x, so I do think we need
> to mention this so people will know to remove it from their
> postgresql.conf before upgrades,
On Tue, May 18, 2021 at 08:34:55AM -0700, Peter Geoghegan wrote:
> In my opinion this should be interpreted as already handled by the
> backpatch to 13.3, and so not necessary to handle again now -- despite
> the GUC thing. It's possible that no users set the GUC at all, because
> it wasn't particu
On Tue, May 18, 2021 at 8:09 AM Bruce Momjian wrote:
> > I suppose that's true -- maybe it should be listed separately, because
> > the GUC is removed in 14 only.
>
> OK, this is a mess then. Would someone please give me the full text for
> this, including the commit hash(es)? Is the PG 13.3 rel
On Tue, May 18, 2021 at 07:51:00AM -0700, Peter Geoghegan wrote:
> On Tue, May 18, 2021 at 7:44 AM Justin Pryzby wrote:
> > As things stand, in this case I think it *should* be included, since the
> > backpatched change isn't the same as the change to HEAD (removing the GUC).
> > The git_changelog
On Tue, May 18, 2021 at 09:44:09AM -0500, Justin Pryzby wrote:
> As things stand, in this case I think it *should* be included, since the
> backpatched change isn't the same as the change to HEAD (removing the GUC).
> The git_changelog output might well be wrong in this case (or, arguably, the
> "r
On Tue, May 18, 2021 at 7:44 AM Justin Pryzby wrote:
> As things stand, in this case I think it *should* be included, since the
> backpatched change isn't the same as the change to HEAD (removing the GUC).
> The git_changelog output might well be wrong in this case (or, arguably, the
> "remove the
On Tue, May 18, 2021 at 10:07:25AM -0400, Bruce Momjian wrote:
> On Tue, May 18, 2021 at 06:28:49PM +0900, Masahiko Sawada wrote:
> > On Mon, May 10, 2021 at 3:03 PM Bruce Momjian wrote:
> > >
> > > I have committed the first draft of the PG 14 release notes. You can
> > > see the most current b
On Tue, May 18, 2021 at 11:07 PM Bruce Momjian wrote:
>
> On Tue, May 18, 2021 at 06:28:49PM +0900, Masahiko Sawada wrote:
> > On Mon, May 10, 2021 at 3:03 PM Bruce Momjian wrote:
> > >
> > > I have committed the first draft of the PG 14 release notes. You can
> > > see the most current build o
On Tue, May 18, 2021 at 06:28:49PM +0900, Masahiko Sawada wrote:
> On Mon, May 10, 2021 at 3:03 PM Bruce Momjian wrote:
> >
> > I have committed the first draft of the PG 14 release notes. You can
> > see the most current build of them here:
> >
> > https://momjian.us/pgsql_docs/release-
On Mon, May 10, 2021 at 3:03 PM Bruce Momjian wrote:
>
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
>
I think we need to mention in the release note that
vacuum_cleanup
On Mon, May 17, 2021 at 12:45:44PM -0700, Peter Geoghegan wrote:
> I propose that the B-Tree index item (bottom-up index deletion, "Allow
> btree index additions to remove expired index entries to prevent page
> splits") link back to the documentation for those that want to drill
> down:
>
> https
On Mon, May 17, 2021 at 12:45 PM Peter Geoghegan wrote:
> https://www.postgresql.org/docs/14/btree-implementation.html#BTREE-DELETION
This linke currently 404s --
https://www.postgresql.org/docs/devel/btree-implementation.html#BTREE-DELETION
works, though.
--
Peter Geoghegan
I propose that the B-Tree index item (bottom-up index deletion, "Allow
btree index additions to remove expired index entries to prevent page
splits") link back to the documentation for those that want to drill
down:
https://www.postgresql.org/docs/14/btree-implementation.html#BTREE-DELETION
The s
On 2021-May-16, Bruce Momjian wrote:
> OK, what I was trying to say was that if you dump/restore, and the old
> password was md5, the newly-restored password will be md5, but it was
> very unclear. I changed it to this:
>
>
>
>
>
> Change the default of the pass
Hi,
On 5/10/21 2:03 AM, Bruce Momjian wrote:
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
>
> I need clarification on many items, and the document still needs its
> item
On Mon, May 17, 2021 at 04:18:27PM +0900, Fujii Masao wrote:
>
>
> On 2021/05/10 15:03, Bruce Momjian wrote:
> > I have committed the first draft of the PG 14 release notes. You can
> > see the most current build of them here:
> >
> > https://momjian.us/pgsql_docs/release-14.html
>
> Than
On 2021/05/10 15:03, Bruce Momjian wrote:
I have committed the first draft of the PG 14 release notes. You can
see the most current build of them here:
https://momjian.us/pgsql_docs/release-14.html
Thanks a lot!!
I need clarification on many items, and the document still needs
On Sun, May 16, 2021 at 11:17:46PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > OK, I moved the entry into 'data types', and listed two entries instead
> > of one:
>
> >
> > Allow extensions and built-in data types to implement subscripting (Tom
> > Lane)
> >
>
> Bette
Bruce Momjian writes:
> OK, I moved the entry into 'data types', and listed two entries instead
> of one:
>
> Allow extensions and built-in data types to implement subscripting (Tom
> Lane)
>
Better, but Dmitry Dolgov gets the credit not me.
>
> Previou
On Sat, May 15, 2021 at 07:16:18PM -0400, Álvaro Herrera wrote:
> On 2021-May-10, Bruce Momjian wrote:
>
> > I have committed the first draft of the PG 14 release notes. You can
> > see the most current build of them here:
> >
> > https://momjian.us/pgsql_docs/release-14.html
>
> Thanks fo
On Sat, May 15, 2021 at 10:27:08PM -0400, Tom Lane wrote:
> Alvaro Herrera writes:
> > I, um, again think that the item should not be primarily about JSONB,
> > but about our (IMO groundbreaking) extensible subscripting work.
>
> +1. Extensible subscripting is THE feature here, using it for json
On Sat, May 15, 2021 at 07:05:35PM -0400, Álvaro Herrera wrote:
> On 2021-May-12, Bruce Momjian wrote:
>
> > OK, updated text:
> >
> >
> >
> >
> >
> > Change the default of the password_encryption server parameter
> > to scram-sha-256 (Peter Eisentraut)
> >
> >
Alvaro Herrera writes:
> I, um, again think that the item should not be primarily about JSONB,
> but about our (IMO groundbreaking) extensible subscripting work.
+1. Extensible subscripting is THE feature here, using it for jsonb
is just an application.
regards, tom lane
On Sat, May 15, 2021 at 07:12:28PM -0400, Alvaro Herrera wrote:
> On 2021-May-15, Bruce Momjian wrote:
> > On Fri, May 14, 2021 at 04:01:32PM -0400, Bruce Momjian wrote:
> > > On Fri, May 14, 2021 at 03:39:39PM -0400, Tom Lane wrote:
> > > > Bruce Momjian writes:
> > > > > On Thu, May 13, 2021 at
On 2021-May-10, Bruce Momjian wrote:
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
Thanks for putting this all together.
>
>
>
>
> Autovacuum now analyzes partitione
On 2021-May-15, Bruce Momjian wrote:
> On Fri, May 14, 2021 at 04:01:32PM -0400, Bruce Momjian wrote:
> > On Fri, May 14, 2021 at 03:39:39PM -0400, Tom Lane wrote:
> > > Bruce Momjian writes:
> > > > On Thu, May 13, 2021 at 09:01:41PM -0500, Justin Pryzby wrote:
> > > >> New SQL-accessible functi
On 2021-May-12, Bruce Momjian wrote:
> OK, updated text:
>
>
>
>
>
> Change the default of the password_encryption server parameter
> to scram-sha-256 (Peter Eisentraut)
>
>
>
> Previously it was md5. All new passwords will be st
On Fri, May 14, 2021 at 04:01:32PM -0400, Bruce Momjian wrote:
> On Fri, May 14, 2021 at 03:39:39PM -0400, Tom Lane wrote:
> > Bruce Momjian writes:
> > > On Thu, May 13, 2021 at 09:01:41PM -0500, Justin Pryzby wrote:
> > >> New SQL-accessible functionality should be included:
> > >>> 8c15a29745 A
On Fri, May 14, 2021 at 03:39:39PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > On Thu, May 13, 2021 at 09:01:41PM -0500, Justin Pryzby wrote:
> >> New SQL-accessible functionality should be included:
> >>> 8c15a29745 Allow ALTER TYPE to update an existing type's typsubscript
> >>> value.
>
Bruce Momjian writes:
> On Thu, May 13, 2021 at 09:01:41PM -0500, Justin Pryzby wrote:
>> New SQL-accessible functionality should be included:
>>> 8c15a29745 Allow ALTER TYPE to update an existing type's typsubscript value.
> OK, text is:
>
>
>
> Allow ALTER T
On Thu, May 13, 2021 at 09:01:41PM -0500, Justin Pryzby wrote:
> On Mon, May 10, 2021 at 09:40:45AM -0500, Justin Pryzby wrote:
> > Should any of these be included?
>
> New SQL-accessible functionality should be included:
> > 8c15a29745 Allow ALTER TYPE to update an existing type's typsubscript va
On Thu, May 13, 2021 at 09:08:37PM -0500, Justin Pryzby wrote:
> On Thu, May 13, 2021 at 09:01:41PM -0500, Justin Pryzby wrote:
> > These should be merged:
> > > 756ab29124 Allow pageinspect to inspect GiST indexes (Andrey Borodin,
> > > Heikki Linnakangas)
> > > 9e596b65f4 Add "LP_DEAD item?" col
On Thu, May 13, 2021 at 09:01:41PM -0500, Justin Pryzby wrote:
> These should be merged:
> > 756ab29124 Allow pageinspect to inspect GiST indexes (Andrey Borodin,
> > Heikki Linnakangas)
> > 9e596b65f4 Add "LP_DEAD item?" column to GiST pageinspect functions
Sorry, this was my error while reconci
On Mon, May 10, 2021 at 09:40:45AM -0500, Justin Pryzby wrote:
> Should any of these be included?
New SQL-accessible functionality should be included:
> 8c15a29745 Allow ALTER TYPE to update an existing type's typsubscript value.
These should be merged:
> 756ab29124 Allow pageinspect to inspect G
On Thu, May 13, 2021 at 11:59 PM Bruce Momjian wrote:
> On Thu, May 13, 2021 at 02:46:58PM +0900, Amit Langote wrote:
> > How about writing the 2nd line instead as:
> >
> > Updates/deletes on partitioned tables can now use execution-time
> > partition pruning.
> >
> > We don't seem to use the term
On Mon, May 10, 2021 at 02:03:08AM -0400, Bruce Momjian wrote:
> I have committed the first draft of the PG 14 release notes. You can
> see the most current build of them here:
>
> https://momjian.us/pgsql_docs/release-14.html
>
> I need clarification on many items, and the document still
On Thu, May 13, 2021 at 02:46:58PM +0900, Amit Langote wrote:
> How about writing the 2nd line instead as:
>
> Updates/deletes on partitioned tables can now use execution-time
> partition pruning.
>
> We don't seem to use the term "run-time pruning" anywhere else in the
> documentation, and "prun
On Thu, May 13, 2021 at 2:39 AM Bruce Momjian wrote:
> On Tue, May 11, 2021 at 11:57:10AM +0900, Amit Langote wrote:
> > On Mon, May 10, 2021 at 11:40 PM Justin Pryzby wrote:
> > > 86dc90056d Rework planning and execution of UPDATE and DELETE.
> > > a1115fa078 Postpone some more stuff out of Exec
On Wed, May 12, 2021 at 06:19:28PM -0400, Álvaro Herrera wrote:
> > I am hesitant to merge them since they are different changes.
>
> Different? The commit IDs look pretty similar to me, not to say exactly
> identical.
>
> Reading these, it's pretty unclear what password_encryption *is* in the
>
On Wed, May 12, 2021 at 06:06:31PM -0400, Álvaro Herrera wrote:
> On 2021-May-12, Bruce Momjian wrote:
>
> > OK, I added it into the existing entry:
> >
> >
> >
> >
> >
> > Allow subscripting of jsonb (Dmitry Dolgov)
> >
> >
> >
> > Subscripting can be u
On Mon, May 10, 2021 at 02:42:08PM -0400, John Naylor wrote:
> Hi Bruce,
>
> Thanks for doing this work again!
>
> > Add date_bin function (John Naylor)
> >
> > WHAT DOES THIS DO?
>
> Hard to describe in a one-liner, but it lines up timestamps into regular
> intervals as specified by the user. I
On 2021-May-10, Bruce Momjian wrote:
> I reworeded it to:
>
>
>
>
>
> Limit the ways password_encryption can enable md5 hashing (Peter
> Eisentraut)
>
>
>
> Previously on/true/yes/1 values enabled md5. Now, only the string md5
> does
On 2021-May-12, Bruce Momjian wrote:
> OK, I added it into the existing entry:
>
>
>
>
>
> Allow subscripting of jsonb (Dmitry Dolgov)
>
>
>
> Subscripting can be used to extract from and assign to jsonb documents.
> Subscripting
On Tue, May 11, 2021 at 05:47:27PM -0400, Álvaro Herrera wrote:
> On 2021-May-11, Bruce Momjian wrote:
>
> > > 86dc90056d Rework planning and execution of UPDATE and DELETE.
> > > a1115fa078 Postpone some more stuff out of ExecInitModifyTable.
> > > c5b7ba4e67 Postpone some stuff out of ExecInitMo
On Tue, May 11, 2021 at 11:57:10AM +0900, Amit Langote wrote:
> On Mon, May 10, 2021 at 11:40 PM Justin Pryzby wrote:
> > 86dc90056d Rework planning and execution of UPDATE and DELETE.
> > a1115fa078 Postpone some more stuff out of ExecInitModifyTable.
> > c5b7ba4e67 Postpone some stuff out of Exe
On Wed, May 12, 2021 at 10:06:05AM -0500, Justin Pryzby wrote:
> On Tue, May 11, 2021 at 10:45:04PM -0400, Bruce Momjian wrote:
> > OK, so this is where I am confused. I searched for distinguished name
> > (DN) and came up with DN being a concatentation of all the fields
> > provided to the certif
1 - 100 of 173 matches
Mail list logo
