On Tue, 27 Sept 2022 at 10:45, Tom Lane wrote:
>
> David Rowley writes:
> > On Tue, 13 Sept 2022 at 09:31, Jonathan S. Katz
> > wrote:
> >> Separately, per[1], including dense_rank() in the list of window
> >> functions with optimizations (dense-rank.diff).
>
> > This one might have been forgot
David Rowley writes:
> On Tue, 13 Sept 2022 at 09:31, Jonathan S. Katz wrote:
>> Separately, per[1], including dense_rank() in the list of window
>> functions with optimizations (dense-rank.diff).
> This one might have been forgotten... ? I can push it shortly if nobody
> objects.
Yeah, I miss
On Tue, 13 Sept 2022 at 09:31, Jonathan S. Katz wrote:
> Separately, per[1], including dense_rank() in the list of window
> functions with optimizations (dense-rank.diff).
This one might have been forgotten... ? I can push it shortly if nobody objects.
David
> [1]
> https://www.postgresql.org/m
Justin Pryzby writes:
> On Fri, Sep 23, 2022 at 01:33:07PM -0400, Tom Lane wrote:
> +Previously such files were left in the current directory,
> +requiring manual cleanup. It's still necessary to remove them
> +manually afterwards, but now one can just remove that whole
>
On Fri, Sep 23, 2022 at 01:33:07PM -0400, Tom Lane wrote:
> "Jonathan S. Katz" writes:
> > On 9/23/22 11:25 AM, Tom Lane wrote:
> >> I'm planning to do a final(?) pass over the v15 notes today,
> >> but I thought it'd be appropriate to push this separately.
>
> > RE "final pass", there's still an
On 9/23/22 1:33 PM, Tom Lane wrote:
"Jonathan S. Katz" writes:
On 9/23/22 11:25 AM, Tom Lane wrote:
I'm planning to do a final(?) pass over the v15 notes today,
but I thought it'd be appropriate to push this separately.
RE "final pass", there's still an errant "BACKPATCHED"[1] that still
ne
"Jonathan S. Katz" writes:
> On 9/23/22 11:25 AM, Tom Lane wrote:
>> I'm planning to do a final(?) pass over the v15 notes today,
>> but I thought it'd be appropriate to push this separately.
> RE "final pass", there's still an errant "BACKPATCHED"[1] that still
> needs addressing. I didn't have
On 9/23/22 11:25 AM, Tom Lane wrote:
"Jonathan S. Katz" writes:
Adjusted to be similar to your suggestion. Updated patch attached.
I pushed this with a bit more copy-editing.
I'm planning to do a final(?) pass over the v15 notes today,
but I thought it'd be appropriate to push this separatel
"Jonathan S. Katz" writes:
> Adjusted to be similar to your suggestion. Updated patch attached.
I pushed this with a bit more copy-editing.
I'm planning to do a final(?) pass over the v15 notes today,
but I thought it'd be appropriate to push this separately.
regards, to
On 9/13/22 7:13 AM, Alvaro Herrera wrote:
On 2022-Sep-12, Jonathan S. Katz wrote:
+
+
+ Column-level and row-level filtering on
+ logical replication
+ publications.
+
+
-column-level filtering
+the ability to specify column lists
Adjusted to be similar to y
On 2022-Sep-12, Jonathan S. Katz wrote:
> +
> +
> + Column-level and row-level filtering on
> + logical replication
> + publications.
> +
> +
-column-level filtering
+the ability to specify column lists
> + Row-level filtering and the ability to specify colu
On 9/4/22 2:42 PM, Nathan Bossart wrote:
I noticed that the v15 release notes still refer to pg_checkpointer, which
was renamed to pg_checkpoint in b9eb0ff.
diff --git a/doc/src/sgml/release-15.sgml b/doc/src/sgml/release-15.sgml
index d432c2db44..362728753a 100644
--- a/doc/src/sgml/release-15.
I noticed that the v15 release notes still refer to pg_checkpointer, which
was renamed to pg_checkpoint in b9eb0ff.
diff --git a/doc/src/sgml/release-15.sgml b/doc/src/sgml/release-15.sgml
index d432c2db44..362728753a 100644
--- a/doc/src/sgml/release-15.sgml
+++ b/doc/src/sgml/release-15.sgml
@@
On 5/10/22 11:44 AM, Bruce Momjian wrote:
I have completed the first draft of the PG 15 release notes
I assume there will be major adjustments in the next few weeks based on
feedback.
I wanted to propose the "major enhancements" section to see if we can
get an iteration in prior to Beta 4.
On Wed, Aug 31, 2022 at 04:03:06PM -0400, Bruce Momjian wrote:
> On Wed, Aug 31, 2022 at 11:38:33AM +0200, Peter Eisentraut wrote:
> > On 30.08.22 22:42, Bruce Momjian wrote:
> > > I just can't figure out what the user needs to understand about this,
> > > and I understand very little of it.
> >
>
On Wed, Aug 31, 2022 at 11:38:33AM +0200, Peter Eisentraut wrote:
> On 30.08.22 22:42, Bruce Momjian wrote:
> > Good question --- the full text is:
> >
> >
> >
> > Record and check the collation of each > linkend="sql-createdatabase">database (Peter Eisentraut)
> >
On 30.08.22 22:42, Bruce Momjian wrote:
Good question --- the full text is:
Record and check the collation of each database (Peter Eisentraut)
This is designed to detect collation
mismatches to avoid data corruption. Function
pg_da
On Sat, Aug 27, 2022 at 04:03:02PM +0200, Matthias van de Meent wrote:
> Hi,
>
> I noticed a stray "DETAILS?" marker while going through the release
> notes for 15. Is that subsection still under construction or review?
>
> >
> >
> > Record and check the collation of each >
Hi,
I noticed a stray "DETAILS?" marker while going through the release
notes for 15. Is that subsection still under construction or review?
>
>
> Record and check the collation of eachlinkend="sql-createdatabase">database (Peter Eisentraut)
> [...]
> to match the op
On Tue, Jul 12, 2022 at 02:47:07PM -0400, Bruce Momjian wrote:
> On Mon, Jul 11, 2022 at 11:31:32PM -0700, Noah Misch wrote:
> > On Mon, Jul 11, 2022 at 12:39:57PM -0400, Bruce Momjian wrote:
> > > I had trouble reading the sentences in the order you used so I
> > > restructured it:
> > >
> > >
On Tue, Jul 19, 2022 at 01:13:07PM -0500, Justin Pryzby wrote:
> On Tue, Jul 19, 2022 at 01:24:30PM -0400, Bruce Momjian wrote:
> > Well, I put the --no-synchronized-snapshots item in incompatibilities
> > since it is a user-visible change that might require script adjustments.
> > However, I put t
On Tue, Jul 19, 2022 at 01:24:30PM -0400, Bruce Momjian wrote:
> > > Remove pg_dump's --no-synchronized-snapshots option since all supported
> > > server versions support synchronized snapshots (Tom Lane)
> >
> > It'd be better to put that after the note about dropping support for
> > upgrading
On Mon, Jul 18, 2022 at 08:23:23PM -0500, Justin Pryzby wrote:
> > Increase hash_mem_multiplier default to 2.0 (Peter Geoghegan)
> > This allows query hash operations to use double the amount of work_mem
> > memory as other operations.
>
> I wonder if it's worth pointing out that a query may end
> Increase hash_mem_multiplier default to 2.0 (Peter Geoghegan)
> This allows query hash operations to use double the amount of work_mem memory
> as other operations.
I wonder if it's worth pointing out that a query may end up using not just 2x
more memory (since work_mem*hash_mem_multiplier is p
On Thu, Jul 14, 2022 at 01:24:41PM +0700, John Naylor wrote:
> Regarding this item:
>
> "Allow hash lookup for NOT IN clauses with many constants (David Rowley, James
> Coleman)
> Previously the code always sequentially scanned the list of values."
>
> The todo list has an entry titled "Planning
Regarding this item:
"Allow hash lookup for NOT IN clauses with many constants (David Rowley,
James Coleman)
Previously the code always sequentially scanned the list of values."
The todo list has an entry titled "Planning large IN lists", which links to
https://www.postgresql.org/message-id/1178
On Mon, Jul 11, 2022 at 11:31:32PM -0700, Noah Misch wrote:
> On Mon, Jul 11, 2022 at 12:39:57PM -0400, Bruce Momjian wrote:
> > I had trouble reading the sentences in the order you used so I
> > restructured it:
> >
> > The new default is one of the secure schema usage patterns that > li
On Mon, Jul 11, 2022 at 12:39:57PM -0400, Bruce Momjian wrote:
> I had trouble reading the sentences in the order you used so I
> restructured it:
>
> The new default is one of the secure schema usage patterns thatlinkend="ddl-schemas-patterns"/> has recommended since the security
>
On Mon, Jul 11, 2022 at 12:39:23PM -0500, Justin Pryzby wrote:
> On Tue, May 10, 2022 at 11:41:08PM -0400, Bruce Momjian wrote:
> > On Tue, May 10, 2022 at 08:31:17PM -0500, Justin Pryzby wrote:
>
> > > | Store server-level statistics in shared memory (Kyotaro Horiguchi,
> > > Andres Freund, Mela
On Tue, May 10, 2022 at 11:41:08PM -0400, Bruce Momjian wrote:
> On Tue, May 10, 2022 at 08:31:17PM -0500, Justin Pryzby wrote:
> > | Store server-level statistics in shared memory (Kyotaro Horiguchi, Andres
> > Freund, Melanie Plageman)
> >
> > Should this be called "cumulative" statistics? As
On Sat, Jul 9, 2022 at 08:19:41PM -0700, Noah Misch wrote:
> > I think you would need to say "previous behavior" since people might be
> > upgrading from releases before PG 14. I also would change "In existing
>
> I felt "previous behavior" was mildly ambiguous. I've changed it to "the
> behavi
On Wed, Jul 06, 2022 at 09:10:53AM -0400, Bruce Momjian wrote:
> On Tue, Jul 5, 2022 at 07:45:57PM -0700, Noah Misch wrote:
> > On Tue, Jul 05, 2022 at 07:47:52PM -0400, Bruce Momjian wrote:
> > > Yes, I think it is a question of practicality vs. desirability. We are
> > > basically telling peopl
On Tue, Jul 5, 2022 at 07:45:57PM -0700, Noah Misch wrote:
> On Tue, Jul 05, 2022 at 07:47:52PM -0400, Bruce Momjian wrote:
> > Yes, I think it is a question of practicality vs. desirability. We are
> > basically telling people they have to do research to get the old
> > behavior in their new dat
On Tue, Jul 05, 2022 at 07:47:52PM -0400, Bruce Momjian wrote:
> On Tue, Jul 5, 2022 at 02:57:52PM -0700, Noah Misch wrote:
> > Since having too-permissive ACLs is usually symptom-free, I share your
> > forecast about the more-common question. Expect questions on mailing lists,
> > stackoverflow,
On Tue, Jul 5, 2022 at 02:57:52PM -0700, Noah Misch wrote:
> Since having too-permissive ACLs is usually symptom-free, I share your
> forecast about the more-common question. Expect questions on mailing lists,
> stackoverflow, etc. The right way to answer those questions is roughly this:
>
>
On Tue, Jul 05, 2022 at 04:35:32PM -0400, Bruce Momjian wrote:
> On Tue, Jul 5, 2022 at 12:53:49PM -0700, Noah Misch wrote:
> > On Tue, Jul 05, 2022 at 02:35:39PM -0400, Bruce Momjian wrote:
> > > On Fri, Jul 1, 2022 at 06:21:28PM -0700, Noah Misch wrote:
> > > > Here's what I've been trying to a
On Tue, Jul 5, 2022 at 12:53:49PM -0700, Noah Misch wrote:
> On Tue, Jul 05, 2022 at 02:35:39PM -0400, Bruce Momjian wrote:
> > On Fri, Jul 1, 2022 at 06:21:28PM -0700, Noah Misch wrote:
> > > Here's what I've been trying to ask: what do you think of linking to
> > > https://www.postgresql.org/do
On Tue, Jul 05, 2022 at 02:35:39PM -0400, Bruce Momjian wrote:
> On Fri, Jul 1, 2022 at 06:21:28PM -0700, Noah Misch wrote:
> > Here's what I've been trying to ask: what do you think of linking to
> > https://www.postgresql.org/docs/devel/ddl-schemas.html#DDL-SCHEMAS-PATTERNS
> > here? The releas
On Tue, Jul 5, 2022 at 11:51:31AM -0700, Peter Geoghegan wrote:
> On Tue, Jul 5, 2022 at 11:09 AM Bruce Momjian wrote:
> >
> > Actually, I was wrong. I thought that we only mentioned that we
> > computed a more agressive xid, but now see I was mentioning the _frozen_
> > xid. Reading the commit
On Tue, Jul 5, 2022 at 11:09 AM Bruce Momjian wrote:
>
> Actually, I was wrong. I thought that we only mentioned that we
> computed a more agressive xid, but now see I was mentioning the _frozen_
> xid. Reading the commit, we do compute the multi-xid and store that too
> so I have updated the PG
On Fri, Jul 1, 2022 at 06:21:28PM -0700, Noah Misch wrote:
> Here's what I've been trying to ask: what do you think of linking to
> https://www.postgresql.org/docs/devel/ddl-schemas.html#DDL-SCHEMAS-PATTERNS
> here? The release note text is still vague, and the docs have extensive
> coverage of t
On Sat, Jul 2, 2022 at 08:13:41PM -0400, Bruce Momjian wrote:
> On Fri, Jul 1, 2022 at 09:56:17AM -0700, Peter Geoghegan wrote:
> > On Fri, Jul 1, 2022 at 9:41 AM Bruce Momjian wrote:
> > > > It might be worth explaining the shift directly in the release notes.
> > > > The new approach is simple
>
> Okay, thanks Bruce.
--
Peter Geoghegan
On Fri, Jul 1, 2022 at 09:56:17AM -0700, Peter Geoghegan wrote:
> On Fri, Jul 1, 2022 at 9:41 AM Bruce Momjian wrote:
> > > It might be worth explaining the shift directly in the release notes.
> > > The new approach is simpler and makes a lot more sense -- why should
> > > the relfrozenxid be cl
On Fri, Jul 01, 2022 at 02:08:00PM -0400, Bruce Momjian wrote:
> On Wed, Jun 29, 2022 at 10:08:08PM -0700, Noah Misch wrote:
> > On Tue, Jun 28, 2022 at 04:35:45PM -0400, Bruce Momjian wrote:
> > > > > permissions on the public schema has not
> > > > > been changed. Databases restored
On Wed, Jun 29, 2022 at 10:08:08PM -0700, Noah Misch wrote:
> On Tue, Jun 28, 2022 at 04:35:45PM -0400, Bruce Momjian wrote:
> > > If you dump/reload an unmodified v14 template1 (as pg_dumpall and
> > > pg_upgrade
> > > do), your v15 template1 will have a v14 ACL on its public schema. At that
> >
On Fri, Jul 1, 2022 at 9:41 AM Bruce Momjian wrote:
> > It might be worth explaining the shift directly in the release notes.
> > The new approach is simpler and makes a lot more sense -- why should
> > the relfrozenxid be closely tied to freezing? We don't necessarily
>
> I don't think this is an
On Tue, Jun 28, 2022 at 05:32:26PM -0700, Peter Geoghegan wrote:
> The main enhancement to VACUUM for Postgres 15 was item 1, which
> taught VACUUM to dynamically track the oldest remaining XID (and the
> oldest remaining MXID) that will remain in the table at the end of the
> same VACUUM operation
On Tue, Jun 28, 2022 at 04:35:45PM -0400, Bruce Momjian wrote:
> On Mon, Jun 27, 2022 at 11:37:19PM -0700, Noah Misch wrote:
> > On Tue, May 10, 2022 at 11:44:15AM -0400, Bruce Momjian wrote:
> > > I have completed the first draft of the PG 15 release notes
> >
> > >
> > >
> > >
> > >
On Tue, Jun 28, 2022 at 1:35 PM Bruce Momjian wrote:
> Okay, text updated, thanks. Applied patch attached.
I have some notes on these items:
1. "Allow vacuum to be more aggressive in setting the oldest frozenxid
(Peter Geoghegan)"
2. "Add additional information to VACUUM VERBOSE and autovacuum
On Mon, Jun 27, 2022 at 11:37:19PM -0700, Noah Misch wrote:
> On Tue, May 10, 2022 at 11:44:15AM -0400, Bruce Momjian wrote:
> > I have completed the first draft of the PG 15 release notes
>
> >
> >
> >
> >
> > Remove PUBLIC creation permission on the > linkend="ddl-schem
On Tue, May 10, 2022 at 11:44:15AM -0400, Bruce Momjian wrote:
> I have completed the first draft of the PG 15 release notes
>
>
>
>
> Remove PUBLIC creation permission on thelinkend="ddl-schemas-public">public schema
> (Noah Misch)
>
>
>
> This
On Thu, May 26, 2022 at 11:17 AM Bruce Momjian wrote:
> On Thu, May 26, 2022 at 10:31:14AM +0900, Amit Langote wrote:
> > * I think it's better to s/...or a LIST partition/...or with a LIST
> > partition
> >
> > * The capitalization of DEFAULT and LIST seems unnecessary.
> >
> > Updated the patch
On Thu, May 26, 2022 at 10:31:14AM +0900, Amit Langote wrote:
> * I think it's better to s/...or a LIST partition/...or with a LIST partition
>
> * The capitalization of DEFAULT and LIST seems unnecessary.
>
> Updated the patch on those points.
I went with this text:
Previously, a parti
On Wed, May 25, 2022 at 1:04 PM Amit Langote wrote:
> On Wed, May 25, 2022 at 12:44 PM David Rowley wrote:
> > On Wed, 25 May 2022 at 15:01, Amit Langote wrote:
> > > +Previously, a partitioned table with DEFAULT partition or a LIST
> > > partition containing multiple values could not be used fo
On Wed, May 25, 2022 at 12:44 PM David Rowley wrote:
> On Wed, 25 May 2022 at 15:01, Amit Langote wrote:
> > +Previously, a partitioned table with DEFAULT partition or a LIST
> > partition containing multiple values could not be used for ordered
> > partition scans. Now it can be used at least in
On Wed, 25 May 2022 at 15:01, Amit Langote wrote:
> +Previously, a partitioned table with DEFAULT partition or a LIST
> partition containing multiple values could not be used for ordered
> partition scans. Now it can be used at least in the cases where such
> partitions are pruned.
I think this o
On Wed, May 25, 2022 at 8:36 AM Bruce Momjian wrote:
> On Thu, May 19, 2022 at 06:13:28PM +0900, Amit Langote wrote:
> > Or maybe we could mention that but use a wording that doesn't make it
> > sound like an implementation detail, like:
> >
> > +Previously, an ordered partition scan could not be
On Thu, May 19, 2022 at 06:13:28PM +0900, Amit Langote wrote:
> Or maybe we could mention that but use a wording that doesn't make it
> sound like an implementation detail, like:
>
> +Previously, an ordered partition scan could not be used for a
> LIST-partitioned table with any partition containi
On Tue, May 24, 2022 at 12:16:10PM +0700, John Naylor wrote:
> On Mon, May 16, 2022 at 9:18 PM Bruce Momjian wrote:
> >
> > Newer wording:
> >
> > Improve validation of UTF-8 text (even if only ASCII) by processing
> > 16 bytes at a time (John Naylor)
>
> Thanks! I also think Heik
On Mon, May 16, 2022 at 9:18 PM Bruce Momjian wrote:
>
> Newer wording:
>
> Improve validation of UTF-8 text (even if only ASCII) by processing
> 16 bytes at a time (John Naylor)
Thanks! I also think Heikki should be mentioned as a coauthor here --
the ASCII coding was his work in
On Thu, May 19, 2022 at 2:56 PM David Rowley wrote:
> On Thu, 19 May 2022 at 14:41, Amit Langote wrote:
> > Though a bit late given beta is now wrapped, I have another partition
> > item wording improvement suggestion:
> >
> > -Previously, a partitioned table with any LIST partition containing
>
On Thu, 19 May 2022 at 14:41, Amit Langote wrote:
> Though a bit late given beta is now wrapped, I have another partition
> item wording improvement suggestion:
>
> -Previously, a partitioned table with any LIST partition containing
> multiple values could not be used for ordered partition scans.
On Sat, May 14, 2022 at 12:42 AM Bruce Momjian wrote:
> On Fri, May 13, 2022 at 10:48:41AM +0900, Amit Langote wrote:
> > Btw, perhaps the following should be listed under E.1.3.2.1. Logical
> > Replication, not E.1.3.1.1. Partitioning?
> >
> >
> >
> >
> >
> > Remove incorrect duplicate partiti
On Mon, May 16, 2022 at 11:02:39AM -0500, Justin Pryzby wrote:
> On Mon, May 16, 2022 at 05:41:08PM +0200, Alvaro Herrera wrote:
> > On 2022-May-10, Bruce Momjian wrote:
> >
> > > I have completed the first draft of the PG 15 release notes and you can
> > > see the results here:
> > >
> > >
On Mon, May 16, 2022 at 05:41:08PM +0200, Alvaro Herrera wrote:
> On 2022-May-10, Bruce Momjian wrote:
>
> > I have completed the first draft of the PG 15 release notes and you can
> > see the results here:
> >
> > https://momjian.us/pgsql_docs/release-15.html
>
> Just to be clear -- 15b
On 2022-May-10, Bruce Momjian wrote:
> I have completed the first draft of the PG 15 release notes and you can
> see the results here:
>
> https://momjian.us/pgsql_docs/release-15.html
Just to be clear -- 15beta1 will be released with the "new features and
enhancements" list as empty, is
On Mon, May 16, 2022 at 10:09:18AM -0400, Bruce Momjian wrote:
> On Mon, May 16, 2022 at 01:21:22PM +0700, John Naylor wrote:
> > Hi Bruce,
> >
> > "Improve validation of ASCII and UTF-8 text by processing 16 bytes at
> > a time (John Naylor)"
> >
> > The reader might assume here that ASCII is op
On Mon, May 16, 2022 at 01:21:22PM +0700, John Naylor wrote:
> Hi Bruce,
>
> "Improve validation of ASCII and UTF-8 text by processing 16 bytes at
> a time (John Naylor)"
>
> The reader might assume here that ASCII is optimized regardless of
> encoding, but it is only optimized in the context of
Hi Bruce,
"Improve validation of ASCII and UTF-8 text by processing 16 bytes at
a time (John Naylor)"
The reader might assume here that ASCII is optimized regardless of
encoding, but it is only optimized in the context of UTF-8. So I would
just mention UTF-8.
Thanks!
--
John Naylor
EDB: http:/
On Saturday, May 14, 2022 12:07 AM 'Bruce Momjian' wrote:
> On Fri, May 13, 2022 at 01:36:04AM +, osumi.takami...@fujitsu.com wrote:
> > >
> > > This is enabled with the subscriber option "disable_on_error"
> > > and avoids possible infinite loops during stream application.
> > >
> >
On Sat, May 14, 2022 at 10:22:10AM +0530, Amit Kapila wrote:
> > I see the point now --- new item:
> >
> >
> >
> >
> >
> > Prevent logical replication of empty transactions (Ajin Cherian,
> > Hou Zhijie, Euler Taveira)
> >
> >
> >
> >
On Fri, May 13, 2022 at 9:18 PM Bruce Momjian wrote:
>
> On Fri, May 13, 2022 at 08:24:53AM +0530, Amit Kapila wrote:
> > On Fri, May 13, 2022 at 6:02 AM Euler Taveira wrote:
> > >
> > > On Thu, May 12, 2022, at 11:22 AM, Bruce Momjian wrote:
> > >
> > > On Thu, May 12, 2022 at 11:12:54AM -0300,
On Fri, May 13, 2022 at 08:24:53AM +0530, Amit Kapila wrote:
> On Fri, May 13, 2022 at 6:02 AM Euler Taveira wrote:
> >
> > On Thu, May 12, 2022, at 11:22 AM, Bruce Momjian wrote:
> >
> > On Thu, May 12, 2022 at 11:12:54AM -0300, Euler Taveira wrote:
> > OB> On Thu, May 12, 2022, at 11:03 AM, Bruc
On Fri, May 13, 2022 at 10:48:41AM +0900, Amit Langote wrote:
> On Thu, May 12, 2022 at 10:52 PM Bruce Momjian wrote:
> > Okay, I went with:
> >
> > Previously, such updates ran delete actions on the source
> > partition and insert actions on the target partition. PostgreSQL
> >
On Fri, May 13, 2022 at 01:36:04AM +, osumi.takami...@fujitsu.com wrote:
> >
> > This is enabled with the subscriber option "disable_on_error"
> > and avoids possible infinite loops during stream application.
> >
> >
> Thank you !
>
> In this last paragraph, how about re
On Fri, May 13, 2022 at 6:02 AM Euler Taveira wrote:
>
> On Thu, May 12, 2022, at 11:22 AM, Bruce Momjian wrote:
>
> On Thu, May 12, 2022 at 11:12:54AM -0300, Euler Taveira wrote:
> OB> On Thu, May 12, 2022, at 11:03 AM, Bruce Momjian wrote:
> >
> > I looked at that but thought that everyone w
On Fri, May 13, 2022 at 11:44 AM Amit Kapila wrote:
> On Fri, May 13, 2022 at 7:19 AM Amit Langote wrote:
> >
> > On Thu, May 12, 2022 at 10:52 PM Bruce Momjian wrote:
> > > Okay, I went with:
> > >
> > > Previously, such updates ran delete actions on the source
> > > partition a
On Fri, May 13, 2022 at 7:19 AM Amit Langote wrote:
>
> On Thu, May 12, 2022 at 10:52 PM Bruce Momjian wrote:
> > Okay, I went with:
> >
> > Previously, such updates ran delete actions on the source
> > partition and insert actions on the target partition. PostgreSQL
> > will
>
On Thu, May 12, 2022 at 10:52 PM Bruce Momjian wrote:
> Okay, I went with:
>
> Previously, such updates ran delete actions on the source
> partition and insert actions on the target partition. PostgreSQL will
> now run update actions on the referenced partition root.
WFM,
On Thursday, May 12, 2022 11:10 PM 'Bruce Momjian' wrote:
> On Thu, May 12, 2022 at 01:35:39PM +, osumi.takami...@fujitsu.com
> wrote:
> > I'd like to suggest that we mention a new option for subscription
> 'disable_on_error'.
> >
> >
> >
> https://github.com/postgres/postgres/commit/705e20f85
On Thu, May 12, 2022, at 11:22 AM, Bruce Momjian wrote:
> On Thu, May 12, 2022 at 11:12:54AM -0300, Euler Taveira wrote:
> OB> On Thu, May 12, 2022, at 11:03 AM, Bruce Momjian wrote:
> >
> > I looked at that but thought that everyone would already assume we
> > skipped replication of empty
On Thu, May 12, 2022 at 08:05:40PM +0530, vignesh C wrote:
> I wonder if this is worth mentioning:
>
> Raise a WARNING for missing publications.
> commit 8f2e2bbf145384784bad07a96d461c6bbd91f597
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8f2e2bbf145384784bad07a96d461c6
I wonder if this is worth mentioning:
Raise a WARNING for missing publications.
commit 8f2e2bbf145384784bad07a96d461c6bbd91f597
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8f2e2bbf145384784bad07a96d461c6bbd91f597
Regards,
Vignesh
On Thu, May 12, 2022 at 7:52 PM Bruce Mom
On Thu, May 12, 2022 at 11:12:54AM -0300, Euler Taveira wrote:
OB> On Thu, May 12, 2022, at 11:03 AM, Bruce Momjian wrote:
>
> I looked at that but thought that everyone would already assume we
> skipped replication of empty transactions, and I didn't see much impact
> for the user, so
On Thu, May 12, 2022, at 11:03 AM, Bruce Momjian wrote:
> I looked at that but thought that everyone would already assume we
> skipped replication of empty transactions, and I didn't see much impact
> for the user, so I didn't include it.
It certainly has an impact on heavy workloads that replicate
On Thu, May 12, 2022 at 01:35:39PM +, osumi.takami...@fujitsu.com wrote:
> I'd like to suggest that we mention a new option for subscription
> 'disable_on_error'.
>
>
> https://github.com/postgres/postgres/commit/705e20f8550c0e8e47c0b6b20b5f5ffd6ffd9e33
Yes, I missed that one, added:
On Thu, May 12, 2022 at 09:32:48PM +1000, Ajin Cherian wrote:
> On Wed, May 11, 2022 at 1:44 AM Bruce Momjian wrote:
> >
> > I have completed the first draft of the PG 15 release notes and you can
> > see the results here:
> >
> > https://momjian.us/pgsql_docs/release-15.html
> >
> > The f
On Thu, May 12, 2022 at 04:40:49PM +0530, Amit Kapila wrote:
> One more point related to logical replication features:
>
> >
> Add SQL functions to monitor the directory contents of replication
> slots (Bharath Rupireddy)
>
> Specifically, the functions are pg_ls_logicalsnapdir(),
> pg_ls_logical
On Thu, May 12, 2022 at 02:25:36PM +0530, Amit Kapila wrote:
> On Wed, May 11, 2022 at 2:02 AM Bruce Momjian wrote:
> > Yes, sorry, I missed that. Oddly, the unlogged sequence patch was
> > retained, even though there is no value for it on the primary. I
> > removed the sentence that mentioned t
On Thu, May 12, 2022 at 02:27:26PM +0900, Amit Langote wrote:
> > Yes, this is what I needed to know. The updated text is:
> >
> >
> >
> >
> >
> > Improve foreign key behavior of updates on partitioned tables
> > that move rows between partitions (Amit La
On Wednesday, May 11, 2022 12:44 AM Bruce Momjian wrote:
> I have completed the first draft of the PG 15 release notes and you can see
> the
> results here:
>
> https://momjian.us/pgsql_docs/release-15.html
>
> The feature count is similar to recent major releases:
>
> release-
On 5/11/22 10:50 PM, Ian Lawrence Barwick wrote:
2022年5月12日(木) 11:46 Bruce Momjian :
On Thu, May 12, 2022 at 11:40:17AM +0900, Ian Lawrence Barwick wrote:
Looking at the release notes from the point of view of someone who has maybe
not been following the long-running debate on removing exclusi
On Wed, May 11, 2022 at 1:44 AM Bruce Momjian wrote:
>
> I have completed the first draft of the PG 15 release notes and you can
> see the results here:
>
> https://momjian.us/pgsql_docs/release-15.html
>
> The feature count is similar to recent major releases:
>
> release-10 195
>
On Thu, May 12, 2022 at 2:25 PM Amit Kapila wrote:
>
> On Wed, May 11, 2022 at 2:02 AM Bruce Momjian wrote:
> >
> > On Tue, May 10, 2022 at 04:17:59PM -0400, Jonathan Katz wrote:
> > > On 5/10/22 11:44 AM, Bruce Momjian wrote:
> > > > I have completed the first draft of the PG 15 release notes an
On Wed, May 11, 2022 at 2:02 AM Bruce Momjian wrote:
>
> On Tue, May 10, 2022 at 04:17:59PM -0400, Jonathan Katz wrote:
> > On 5/10/22 11:44 AM, Bruce Momjian wrote:
> > > I have completed the first draft of the PG 15 release notes and you can
> > > see the results here:
> > >
> > > https
On Wed, May 11, 2022 at 11:41 PM Bruce Momjian wrote:
> On Wed, May 11, 2022 at 04:02:31PM +0900, Amit Langote wrote:
> > On Wed, May 11, 2022 at 12:44 AM Bruce Momjian wrote:
> > > I have completed the first draft of the PG 15 release notes
> > The commit is intended to only change the behavior
2022年5月12日(木) 11:46 Bruce Momjian :
>
> On Thu, May 12, 2022 at 11:40:17AM +0900, Ian Lawrence Barwick wrote:
> > Looking at the release notes from the point of view of someone who has maybe
> > not been following the long-running debate on removing exclusive backups:
> >
> > "Important-sounding ba
On Thu, May 12, 2022 at 11:40:17AM +0900, Ian Lawrence Barwick wrote:
> Looking at the release notes from the point of view of someone who has maybe
> not been following the long-running debate on removing exclusive backups:
>
> "Important-sounding backup thing is suddenly gone! What was that
> ag
Bruce Momjian writes:
> On Thu, May 12, 2022 at 10:37:56AM +0900, Ian Lawrence Barwick wrote:
Remove exclusive backup mode (David Steele, Nathan Bossart)
>> It'd be useful to mention exclusive backup mode has been deprecated since
>> 9.6,
>> lest the impression arise that an important-sound
1 - 100 of 150 matches
Mail list logo
