Re: Unknown annotation '-cim' in source code

2024-07-05 Thread Bruce Momjian
or as one of the 39 Berkely contributors: https://momjian.us/main/blogs/pgblog/2015.html#August_5_2015 https://www.youtube.com/watch?v=BbGeKi6T6QI=4269s -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Changing the state of data checksums in a running cluster

2024-07-05 Thread Bruce Momjian
like parallel workers, optimizing rare > > cases, > > etc) for follow-up patches. > > > > I 100% support this approach. Yes, I was very disappointed when restartability sunk the patch, and I saw this as another case where saying "yes" to every feature improve

Re: Should we document how column DEFAULT expressions work?

2024-07-05 Thread Bruce Momjian
On Fri, Jul 5, 2024 at 05:03:35PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > Well, 'now()' certainly _looks_ like a function call, though it isn't. > > The fact that 'now()'::timestamptz and 'now'::timestamptz generate > > volatile results via a function call was my

Re: Should we document how column DEFAULT expressions work?

2024-07-05 Thread Bruce Momjian
On Fri, Jul 5, 2024 at 04:50:32PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > Also interestingly, "now" without quotes requires parentheses to make it > > a function call: > > I'm not sure why you find that surprising, or why you think that > 'now(

Re: First draft of PG 17 release notes

2024-07-05 Thread Bruce Momjian
mmitted a change to use this wording: Allow psql connection attempts to be canceled with control-C (Tristan Partin) -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Should we document how column DEFAULT expressions work?

2024-07-05 Thread Bruce Momjian
o explain this --- I think we need text in the CREATE TABLE ... DEFAULT section. I think the now() case is unusual since there are few cases where function calls can be put inside of single quotes. I have written the attached patch to clarify the behavior. -- Bruce Momjian https:/

Re: Partial aggregates pushdown

2024-07-05 Thread Bruce Momjian
could not connect to server "loopback" > > +DETAIL: invalid connection option "partial_aggregate_support" > Fixed. Is there a reason the documentation is no longer a part of this patch? Can I help you keep it current? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..

2024-06-26 Thread Bruce Momjian
On Wed, Jun 26, 2024 at 09:59:35AM -0400, Bruce Momjian wrote: > On Wed, Jun 26, 2024 at 12:06:13AM -0400, Tom Lane wrote: > > Bruce Momjian writes: > > > On Tue, Jun 25, 2024 at 05:52:47PM -0700, David G. Johnston wrote: > > >> We seem to be missing a release note

Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..

2024-06-26 Thread Bruce Momjian
On Wed, Jun 26, 2024 at 12:06:13AM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Tue, Jun 25, 2024 at 05:52:47PM -0700, David G. Johnston wrote: > >> We seem to be missing a release note item for the catalog breakage done in > >> f696c0c > >>

Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..

2024-06-25 Thread Bruce Momjian
in >  f696c0c > > https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f696c0cd5f It seemed too internal to mention in the release notes --- more of an infrastructure change, but I can add it if I was wrong about this. -- Bruce Momjian https://momjian.us EDB

Re: Proposal for Updating CRC32C with AVX-512 Algorithm.

2024-06-25 Thread Bruce Momjian
cense issue as a blocker for this patch. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: New standby_slot_names GUC in PG 17

2024-06-22 Thread Bruce Momjian
t; > > IMHO that might be a bit too close to synchronous_standby_names. > > > > Right, but better than the current one. The other possibility could be > wait_for_standby_slots. FYI, changing this GUC name could force an initdb because postgresql.conf would have the old name and remov

New standby_slot_names GUC in PG 17

2024-06-21 Thread Bruce Momjian
? It seems too generic. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

PG 17 and GUC variables

2024-06-20 Thread Bruce Momjian
FYI, looking at the release notes, I see 15 GUC variables added in this release, and two removed. That 15 number seemed unusually high so I thought I would report it. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you

Re: Proposal for Updating CRC32C with AVX-512 Algorithm.

2024-06-19 Thread Bruce Momjian
On Tue, Jun 18, 2024 at 02:00:34PM -0400, Bruce Momjian wrote: > While the license we are concerned about does not have this clause, it > does have: > >2. Redistributions in binary form must reproduce the above > copyright notice, this list of conditions an

Re: Proposal for Updating CRC32C with AVX-512 Algorithm.

2024-06-18 Thread Bruce Momjian
On Tue, Jun 18, 2024 at 01:20:50PM -0400, Bruce Momjian wrote: > On Tue, Jun 18, 2024 at 05:14:08PM +, Amonson, Paul D wrote: > > > And this bit doesn't look good. The LICENSE file says: > > ... > > > > //* Redistributions in binary form must reproduce

Re: Proposal for Updating CRC32C with AVX-512 Algorithm.

2024-06-18 Thread Bruce Momjian
se already appears in the PostgreSQL source tree. I > might have misunderstood the concern, but the lawyer believes this is a > non-issue. Could you please provide more clarifying details about the concern? Yes, I can confirm that: grep -Rl 'Redistributions in binary form must reprod

Re: PostgreSQL 17 Beta 2 release date & commit freeze

2024-06-18 Thread Bruce Momjian
d by June 22, 2024. I am adding markup to the PG 17 release notes and will be finished by this Friday. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Missing docs for new enable_group_by_reordering GUC

2024-06-17 Thread Bruce Momjian
someone please add docs for this? Thanks. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Proposal for Updating CRC32C with AVX-512 Algorithm.

2024-06-12 Thread Bruce Momjian
work. You would need to combine the Postgres and Chrome license for this, and I highly doubt we are going to be modifying the Postgres for this. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: First draft of PG 17 release notes

2024-06-05 Thread Bruce Momjian
On Wed, Jun 5, 2024 at 11:46:17PM +0100, Dean Rasheed wrote: > On Thu, 9 May 2024 at 05:03, Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsql_do

Re: Partial aggregates pushdown

2024-06-05 Thread Bruce Momjian
nterval_avg_serialize numeric_poly_serialize I realize we need to return the sum and count for average, so that makes sense. So, we need import/export text representation for the partial aggregate mode for these eight, and call the base data type text import/export functions for the z

Re: Partial aggregates pushdown

2024-06-04 Thread Bruce Momjian
On Wed, Jun 5, 2024 at 12:14:45AM +, fujii.y...@df.mitsubishielectric.co.jp wrote: > I will add sufficient document and comments to the next patch as Bruce and > Robert said. Great, I am available to help improve the documentation. -- Bruce Momjian https://momjian.us

Re: Partial aggregates pushdown

2024-06-04 Thread Bruce Momjian
inary data from the foreign server. Can someone show me where that last item is in the patch, and why can't we just pass back values cast to text? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: First draft of PG 17 release notes

2024-05-27 Thread Bruce Momjian
On Tue, May 28, 2024 at 02:44:28PM +1200, David Rowley wrote: > On Sun, 26 May 2024 at 15:57, Bruce Momjian wrote: > > Agreed. I changed it to: > > > > Allow btree indexes to more efficiently find a set of values, such > > as > >

Re: First draft of PG 17 release notes

2024-05-26 Thread Bruce Momjian
On Sun, May 26, 2024 at 10:10:00AM +0200, Álvaro Herrera wrote: > On 2024-May-25, Bruce Momjian wrote: > > > On Thu, May 23, 2024 at 01:22:51PM +0200, Álvaro Herrera wrote: > > > > Can we make them a single item? Maybe something like > > > > > > : Im

Re: AIX support

2024-05-25 Thread Bruce Momjian
om it > one by one, to see which ones are still needed. Yes, bingo, that is exactly what needs to be done, and for the minimal compiler, gcc, and the most recently supported versions of AIX. -- Bruce Momjian https://momjian.us EDB https://enterpr

Re: First draft of PG 17 release notes

2024-05-25 Thread Bruce Momjian
On Thu, May 23, 2024 at 08:19:15PM -0400, Peter Geoghegan wrote: > On Wed, May 22, 2024 at 6:50 PM Bruce Momjian wrote: > > Agreed, patch applied, thanks. > > The item for my commit 5bf748b8 currently reads: > > "Allow btree indexes to more efficiently find a

Re: First draft of PG 17 release notes

2024-05-25 Thread Bruce Momjian
On Thu, May 23, 2024 at 04:54:28PM -0300, Marcos Pegoraro wrote: > • Rename SLRU columns in system view pg_stat_slru (Alvaro Herrera) > > The column names accepted by pg_stat_slru_rest() are also changed. > > Is pg_stat_slru_rest() correct ?  Oops, typo, fixed, thank

Re: First draft of PG 17 release notes

2024-05-25 Thread Bruce Momjian
stics can now be done with > : pg_stat_reset_shared() or pg_stat_reset_shared(NULL), while SLRU > : statistics can now be reset with pg_stat_reset_shared('slru'), > : pg_stat_reset_slru() and pg_stat_reset_slru(NULL). Andres already suggested improvement for this, and I posted the applied patch. Can y

Re: First draft of PG 17 release notes

2024-05-25 Thread Bruce Momjian
On Fri, May 24, 2024 at 11:23:29AM -0700, Andres Freund wrote: > Hi, > > On 2024-05-22 18:33:03 -0400, Bruce Momjian wrote: > > On Tue, May 21, 2024 at 09:40:28AM -0700, Andres Freund wrote: > > > On 2024-05-18 11:13:54 -0400, Bruce Momjian wrote: > > > I agre

Re: First draft of PG 17 release notes

2024-05-25 Thread Bruce Momjian
On Fri, May 24, 2024 at 10:50:28AM -0700, Andres Freund wrote: > Hi, > > On 2024-05-23 23:27:04 -0400, Bruce Momjian wrote: > > On Thu, May 23, 2024 at 11:11:10PM -0400, Tom Lane wrote: > > > Bruce Momjian writes: > > > I am not sure Bruce tha

Re: First draft of PG 17 release notes

2024-05-23 Thread Bruce Momjian
On Thu, May 23, 2024 at 11:11:10PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Thu, May 23, 2024 at 02:27:07PM +1200, David Rowley wrote: > >> I also don't agree these should be left to "Source code" section. I > >> feel that section is best suited

Re: First draft of PG 17 release notes

2024-05-23 Thread Bruce Momjian
On Thu, May 23, 2024 at 02:27:07PM +1200, David Rowley wrote: > On Thu, 23 May 2024 at 14:01, Bruce Momjian wrote: > > > > On Thu, May 23, 2024 at 01:34:10PM +1200, David Rowley wrote: > > > What is the best way to communicate this stuff so it's easily > > > ident

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
On Thu, May 23, 2024 at 01:34:10PM +1200, David Rowley wrote: > On Thu, 23 May 2024 at 10:04, Bruce Momjian wrote: > > You might have seen in this thread, I do record commits that speed up > > workloads that are user-visible, or specifically make new workloads > > possible.

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
than "slru", > isn't it? > I also found an older release note[1] used single quotes for this like: > > Add pg_stat_reset_shared('bgwriter') to reset the cluster-wide shared > statistics for the background writer (Greg Smith) Agreed, patch applied, tha

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
On Wed, May 22, 2024 at 11:29:06AM +0900, Masahiko Sawada wrote: > I found a typo: > > s/pg_statstatement/pg_stat_statement/ > > I've attached a patch to fix it. Agreed, applied, thanks. -- Bruce Momjian https://momjian.us EDB

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
ngote) > > > > Should be: > > > > Add SQL/JSON constructor functions JSON(), JSON_SCALAR(), and > JSON_SERIALIZE() (Nikita Glukhov, Teodor Sigaev, Oleg Bartunov, > Alexander Korotkov, Andrew Dunstan, Amit Langote) > > Thanks, app

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
On Mon, May 20, 2024 at 11:48:09AM -0700, Jeff Davis wrote: > On Sat, 2024-05-18 at 17:51 -0400, Bruce Momjian wrote: > > Okay, I went with the attached applied patch.  Adjustments? > > I think it should have more emphasis on the actual new feature: a > platform-independent

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
On Tue, May 21, 2024 at 09:40:28AM -0700, Andres Freund wrote: > Hi, > > On 2024-05-18 11:13:54 -0400, Bruce Momjian wrote: > > Please see the email I just posted. There are three goals we have to > > adjust for: > > > > 1. short release notes so they are read

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
aps you could > argue that they were not in fact part of the same project and instead > were just small individual changes -- none of which are individually > worth including in the release notes. I try and group them, but I am sure imperfectly. It is very true that infrastucture chang

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
g large blocks of data to a client (Melih Mutlu) Allow the grouping of file system reads with the new system variable io_combine_limit (Thomas Munro, Andres Freund, Melanie Plageman, Nazir Bilal Yavuz) Do we think more user-invisible

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
; commits related to release note entries. We already do much of the work of > building that list of commits for each entry. That'd allow a reader to find > more details if interested. Yes, it would be cool if they could mouse-over a graphic next to each release note item to get a popup

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
On Tue, May 21, 2024 at 09:27:20AM -0700, Andres Freund wrote: > On 2024-05-18 10:59:47 -0400, Bruce Momjian wrote: > > I agree the impact of performance improvements are often greater than > > the average release note item. However, if people expect Postgres to be > > fa

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
On Mon, May 20, 2024 at 02:47:28PM -0400, Melanie Plageman wrote: > On Mon, May 20, 2024 at 9:37 AM Bruce Momjian wrote: > > > > On Mon, May 20, 2024 at 01:23:02PM +0700, John Naylor wrote: > > > Hi Bruce, thanks for doing this again! > > > > > > I'm a b

Re: First draft of PG 17 release notes

2024-05-20 Thread Bruce Momjian
On Mon, May 20, 2024 at 02:35:37PM -0400, Melanie Plageman wrote: > On Sat, May 18, 2024 at 11:13 AM Bruce Momjian wrote: > > Please see the email I just posted. There are three goals we have to > > adjust for: > > > > 1. short release notes so they are readable &

Re: First draft of PG 17 release notes

2024-05-20 Thread Bruce Momjian
Agreed, patch applied, thanks. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: commitfest.postgresql.org is no longer fit for purpose

2024-05-19 Thread Bruce Momjian
mmitfest, but that's probably > not practical with the current patch volume. What I'm thinking > for the moment is to try to make that happen once a year or so. For me, if someone already knows what the blocker is, it saves me a lot of time if they can state that somewhere. --

Re: First draft of PG 17 release notes

2024-05-19 Thread Bruce Momjian
On Sun, May 19, 2024 at 03:53:38PM +1200, David Rowley wrote: > On Sun, 19 May 2024 at 02:40, Bruce Momjian wrote: > > > > On Thu, May 16, 2024 at 03:35:17PM +1200, David Rowley wrote: > > > "Additionally, vacuum no longer silently imposes a 1GB tuple re

Re: commitfest.postgresql.org is no longer fit for purpose

2024-05-18 Thread Bruce Momjian
mit fest entries, they have to figure out what is holding the patch back from being complete, so they have to read the thread from the beginning. Should there be a clearer way in the commit fest app to specify what is missing? -- Bruce Momjian https://momjian.us EDB

Re: First draft of PG 17 release notes

2024-05-18 Thread Bruce Momjian
On Fri, May 17, 2024 at 01:30:03PM -0700, Jeff Davis wrote: > On Thu, 2024-05-09 at 00:03 -0400, Bruce Momjian wrote: > > I have committed the first draft of the PG 17 release notes;  you can > > see the results here: > > > > https://momjian.us

Re: First draft of PG 17 release notes

2024-05-18 Thread Bruce Momjian
On Fri, May 17, 2024 at 09:22:59PM +0800, jian he wrote: > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momj

Re: First draft of PG 17 release notes

2024-05-18 Thread Bruce Momjian
people will need to read the git logs or > > review the code. Do we use it for anything yet? > > > Yes, certainly, it's used in handling backup manifests. Without it we can't > handle huge manifests. See commits ea7b4e9a2a and 222e11a10a. > > Other uses are in the wo

Re: First draft of PG 17 release notes

2024-05-18 Thread Bruce Momjian
On Thu, May 16, 2024 at 04:29:38PM +0800, jian he wrote: > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsql_doc

Re: First draft of PG 17 release notes

2024-05-18 Thread Bruce Momjian
ading a long document, and I get to a section where I start to wonder, "Why should I care about this?", I start to skim the rest of the document. I am particularly critical if I start to wonder, "Why does the author _think_ I should care about this?" becasue it feels like the author is writing for him/herself and not the audience. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: First draft of PG 17 release notes

2024-05-18 Thread Bruce Momjian
lls us that our work isn't > valued. Yes, but are we willing to add text that every user will have to read just for this purpose? One think we _could_ do is to create a generic performance release note item saying performance has been improved in the following areas, with no more de

Re: First draft of PG 17 release notes

2024-05-18 Thread Bruce Momjian
On Thu, May 16, 2024 at 03:35:17PM +1200, David Rowley wrote: > On Thu, 16 May 2024 at 14:48, Bruce Momjian wrote: > > > > On Wed, May 15, 2024 at 09:13:14AM -0400, Melanie Plageman wrote: > > > Also +1 on the Sawada/Naylor change being on the highlight section of >

Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block

2024-05-17 Thread Bruce Momjian
od way or give > > up. It's a reasonable request, after all. > > I don't think it's reasonable at all. We can't log the XID before it's > assigned, and we can't log the statement after the XID is assigned > without completely changing how the parameter works. I have remo

Re: More links on release-17.html

2024-05-15 Thread Bruce Momjian
mportant features. So, wouldn't it be good to have their own > links, so the reader doesn't need to manually search for that feature ? Yes, it would be nice to have them. I will be looking for them in the coming weeks. I usually choose the closest link. -- Bruce Momjian https://momjian

Re: cataloguing NOT NULL constraints

2024-05-15 Thread Bruce Momjian
On Wed, May 15, 2024 at 09:50:36AM +0200, Álvaro Herrera wrote: > On 2024-May-14, Bruce Momjian wrote: > > > Turns out these commits generated a single release note item, which I > > have now removed with the attached committed patch. > > Hmm, but the commits ab

Re: First draft of PG 17 release notes

2024-05-15 Thread Bruce Momjian
On Thu, May 16, 2024 at 10:39:18AM +0800, jian he wrote: > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsql_doc

Re: First draft of PG 17 release notes

2024-05-15 Thread Bruce Momjian
lease (as David suggested upthread). Agreed, I went with the attached applied patch. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you. diff --git a/doc/src/sgml/release-17.sgml b/doc

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
rbase. I think that test suite was significant to anyone using the TCL/Henry Spencer regex library. If you want your test mentioned, you have to explain why it is useful for users to know about it, or the value it brings them. -- Bruce Momjian https://momjian.us EDB

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
On Wed, May 15, 2024 at 02:03:32PM +1200, David Rowley wrote: > On Wed, 15 May 2024 at 13:00, Bruce Momjian wrote: > > > > On Tue, May 14, 2024 at 03:39:26PM -0400, Melanie Plageman wrote: > > > "Reduce system calls by automatically merging reads up to > > &

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
On Tue, May 14, 2024 at 10:22:35AM +0800, Tender Wang wrote: > > > jian he 于2024年5月9日周四 18:00写道: > > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes;  you can &

Re: cataloguing NOT NULL constraints

2024-05-14 Thread Bruce Momjian
e at other times, so > whatever is needed during pg_upgrade is also likely to be needed at > other times. Maybe that's not sound reasoning for some reason or > other, but that's my intuition. I assume Alvaro is saying that pg_upgrade has only a single session, which is unique and might make t

Re: cataloguing NOT NULL constraints

2024-05-14 Thread Bruce Momjian
938311ef86047aa3c6b741f > b0e96f311985bceba79825214f8e43f65afa653a > > with some significant conflict fixes (mostly in the last one). Turns out these commits generated a single release note item, which I have now removed with the attached committed patch. -- Bruce Momjian

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
On Tue, May 14, 2024 at 03:39:26PM -0400, Melanie Plageman wrote: > On Thu, May 9, 2024 at 12:04 AM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsq

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
On Tue, May 14, 2024 at 02:58:41PM +0100, Pantelis Theodosiou wrote: > On Thu, May 9, 2024 at 5:03 AM Bruce Momjian wrote > > > > > > I welcome feedback. For some reason it was an easier job than usual. > > This looks better if "more case" -> "m

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
On Tue, May 14, 2024 at 02:20:24PM +0200, Jelte Fennema-Nio wrote: > On Tue, 14 May 2024 at 02:56, Bruce Momjian wrote: > > > > On Sat, May 11, 2024 at 10:24:39AM -0400, Joe Conway wrote: > > > On 5/11/24 09:57, Jelte Fennema-Nio wrote: > > > > The buffering c

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
On Tue, May 14, 2024 at 01:34:56PM +0300, Elena Indrupskaya wrote: > Being a technical writer, I attached a small patch that fixes minor language > stuff. You are absolutely correct. Patch applied, thanks. -- Bruce Momjian https://momjian.us

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
On Sat, May 11, 2024 at 03:32:55PM -0400, Andrew Dunstan wrote: > > On 2024-05-09 Th 00:03, Bruce Momjian wrote: > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian

Re: First draft of PG 17 release notes

2024-05-14 Thread Bruce Momjian
On Tue, May 14, 2024 at 10:32:14AM +0800, Andy Fan wrote: > Bruce Momjian writes: > > It was unclear from the commit message exactly what user-visible > > optimization this allowed. Do you have details? > > Yes, It allows the query like "SELECT * FROM t1 WHERE t1.a in

Re: First draft of PG 17 release notes

2024-05-13 Thread Bruce Momjian
essage exactly what user-visible optimization this allowed. Do you have details? > - a8a968a8212ee3ef7f22795c834b33d871fac262 this is an optimizer costing > improvement. Does this allow faster UNION ALL with LIMIT, perhaps? -- Bruce Momjian https://momjian.us EDB

Re: First draft of PG 17 release notes

2024-05-13 Thread Bruce Momjian
On Sat, May 11, 2024 at 10:24:39AM -0400, Joe Conway wrote: > On 5/11/24 09:57, Jelte Fennema-Nio wrote: > > On Fri, 10 May 2024 at 23:31, Tom Lane wrote: > > > > > > Bruce Momjian writes: > > > > I looked at both of these. In both cases I didn't see

Re: First draft of PG 17 release notes

2024-05-13 Thread Bruce Momjian
On Fri, May 10, 2024 at 05:31:33PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Fri, May 10, 2024 at 06:50:54PM +0200, Jelte Fennema-Nio wrote: > >> There are two commits that I think would benefit from being listed > >> (but maybe they are already liste

Re: First draft of PG 17 release notes

2024-05-10 Thread Bruce Momjian
On Fri, May 10, 2024 at 05:31:33PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Fri, May 10, 2024 at 06:50:54PM +0200, Jelte Fennema-Nio wrote: > >> There are two commits that I think would benefit from being listed > >> (but maybe they are already liste

Re: First draft of PG 17 release notes

2024-05-10 Thread Bruce Momjian
On Fri, May 10, 2024 at 06:50:54PM +0200, Jelte Fennema-Nio wrote: > On Thu, 9 May 2024 at 06:04, Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsq

Re: Augmenting the deadlock message with application_name

2024-05-10 Thread Bruce Momjian
On Fri, May 10, 2024 at 08:10:58PM +, Karoline Pauls wrote: > On Friday, 10 May 2024 at 20:17, Bruce Momjian > wrote: > > > > log_line_prefix supports application name --- why would you not use > > that? > > > > log_line_prefix is effective in the serve

Re: First draft of PG 17 release notes

2024-05-10 Thread Bruce Momjian
On Fri, May 10, 2024 at 06:29:11PM +0200, Daniel Verite wrote: > Bruce Momjian wrote: > > > have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsql_docs/release-17.html >

Re: Augmenting the deadlock message with application_name

2024-05-10 Thread Bruce Momjian
Process 194521 (application_name: woof) waits for ShareLock on transaction > 775; > blocked by process 194520. > HINT: See server log for query details. > CONTEXT: while locking tuple (0,2) in relation "q" log_line_prefix supports application name --- why would you not use

Re: First draft of PG 17 release notes

2024-05-10 Thread Bruce Momjian
On Fri, May 10, 2024 at 01:54:30PM +0530, Bharath Rupireddy wrote: > On Thu, May 9, 2024 at 9:34 AM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momj

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 08:40:00PM +0200, Álvaro Herrera wrote: > On 2024-May-09, Bruce Momjian wrote: > > > However, I don't see it mentioned as a release note item in the commit > > message or mentioned in our docs. I suppose the release note text would > > be: > &g

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Fri, May 10, 2024 at 08:05:43AM +1200, Thomas Munro wrote: > On Thu, May 9, 2024 at 4:04 PM Bruce Momjian wrote: > > I welcome feedback. For some reason it was an easier job than usual. > > > 2024-01-25 [820b5af73] jit: Require at least LLVM 10. > > > Require LLVM

Re: PERIOD foreign key feature

2024-05-09 Thread Bruce Momjian
On Wed, May 8, 2024 at 08:47:45PM -0700, Paul Jungwirth wrote: > On 5/8/24 07:44, Bruce Momjian wrote: > > On Wed, May 8, 2024 at 02:29:34PM +0200, Peter Eisentraut wrote: > > > > Yes, David is correct here on all points. I like his suggestion to > > > > clari

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 12:10:11PM -0400, Andrew Dunstan wrote: > > On 2024-05-09 Th 00:03, Bruce Momjian wrote: > > I have committed the first draft of the PG 17 release notes; you can > see the results here: > > https://momjian.us/pgsql

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 11:26:44PM +0800, jian he wrote: > On Thu, May 9, 2024 at 11:12 PM Bruce Momjian wrote: > > > > On Thu, May 9, 2024 at 07:49:55PM +0800, jian he wrote: > > > On Thu, May 9, 2024 at 6:53 PM jian he > > > wrote: > > > >

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 07:49:55PM +0800, jian he wrote: > On Thu, May 9, 2024 at 6:53 PM jian he wrote: > > > > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian wrote: > > > I have committed the first draft of the PG 17 release notes; you can > > > see the result

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
d hash aggregation on ltree columns. > << Yes, please see my previous email where I am asking why being more specific is worse. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 06:53:30PM +0800, jian he wrote: > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian wrote: > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsql_docs/release-17.h

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 11:31:17AM +0100, Dagfinn Ilmari Mannsåker wrote: > Dagfinn Ilmari Mannsåker writes: > > > Bruce Momjian writes: > > > >> I have committed the first draft of the PG 17 release notes; you can > >> see the results here: > >>

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 11:22:06AM +0100, Dagfinn Ilmari Mannsåker wrote: > Bruce Momjian writes: > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsql_docs/release-17.htm

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 06:00:24PM +0800, jian he wrote: > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momjian.us/pgsql_docs

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
tkov, Teodor Sigaev, > Nikita Glukhov, Pavel Borisov, Yura Sokolov. Wow, I try to only list source code items that have some user-facing impact, and I don't think these do. I do realize how important they are though. This gets into the balance of mentioning items _users_ need to kn

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 02:37:57PM +0800, Richard Guo wrote: > > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian wrote: > > I have committed the first draft of the PG 17 release notes;  you can > see the results here: > >         https://momjian.us/pgsql

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 02:17:12PM +0900, Masahiko Sawada wrote: > Hi, > > On Thu, May 9, 2024 at 1:03 PM Bruce Momjian wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https:

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 04:53:38AM +, Bertrand Drouvot wrote: > Hi, > > On Thu, May 09, 2024 at 12:03:50AM -0400, Bruce Momjian wrote: > > I have committed the first draft of the PG 17 release notes; you can > > see the results here: > > > > https://momj

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
not to decide what those are all by himself. Yes, I already have so much of my opinion in the release notes that I prefer others to make that list, and to make the Acknowledgments list at the bottom. -- Bruce Momjian https://momjian.us EDB https:

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
> > The above items and other new features of PostgreSQL 17 are explained in more > detail in the sections below. That is just a place-holder. I changed the bullet text to be: TO BE COMPLETED LATER -- Bruce Momjian https://momjian.us EDB

Re: First draft of PG 17 release notes

2024-05-09 Thread Bruce Momjian
On Thu, May 9, 2024 at 04:44:47PM +1200, David Rowley wrote: > On Thu, 9 May 2024 at 16:04, Bruce Momjian wrote: > > I welcome feedback. For some reason it was an easier job than usual. > > Thanks for working on that. > > > +2023-11-02 [cac169d68] Increase DEFAULT_

  1   2   3   4   5   6   7   8   9   10   >