Re: attndims, typndims still not enforced, but make the value within a sane threshold

2024-09-20 Thread Bruce Momjian
machine, not skipped are all OK. I have been hoping for a patch links this because I feel the existence of these system columns is deceptive since we don't honor them properly. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.c

Re: First draft of PG 17 release notes

2024-09-19 Thread Bruce Momjian
On Thu, Sep 19, 2024 at 12:23:21PM -0400, Robert Haas wrote: > On Wed, Sep 18, 2024 at 9:09 PM Nathan Bossart > wrote: > > On Wed, Sep 18, 2024 at 05:33:18PM -0400, Bruce Momjian wrote: > > > On Tue, Sep 17, 2024 at 10:01:28AM +0200, Jelte Fennema-Nio wrote: > > >&g

Re: First draft of PG 17 release notes

2024-09-18 Thread Bruce Momjian
On Tue, Sep 17, 2024 at 10:01:28AM +0200, Jelte Fennema-Nio wrote: > On Wed, 11 Sept 2024 at 16:10, Bruce Momjian wrote: > > You are right that I do mention changes specifically designed for the > > use of extensions, but there is no mention in the commit message of its > &g

Re: Detailed release notes

2024-09-18 Thread Bruce Momjian
On Tue, Sep 17, 2024 at 08:13:20PM -0400, Bruce Momjian wrote: > I think trying to add text to each item is both redundant and confusing, > because I am guessing that many people will not even know what a commit > is, and will be confused by clicking on the link. > > What I have

Re: Detailed release notes

2024-09-18 Thread Bruce Momjian
On Wed, Sep 18, 2024 at 10:16:48AM -0400, Tom Lane wrote: > Jelte Fennema-Nio writes: > > On Wed, 18 Sept 2024 at 02:55, Bruce Momjian wrote: > >>> Also very clutter-y. I'm not convinced that any of this is a good > >>> idea that will stand the test

Re: Detailed release notes

2024-09-17 Thread Bruce Momjian
On Tue, Sep 17, 2024 at 08:22:41PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Tue, Sep 17, 2024 at 03:29:54PM -0300, Marcos Pegoraro wrote: > >> Em ter., 17 de set. de 2024 às 05:12, Alvaro Herrera > >> > >>> Add backend support for injection

Re: Detailed release notes

2024-09-17 Thread Bruce Momjian
links to. Patch attached. We can still consider a different symbol or number labeling, but I think this patch is in the right direction. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com When a patient asks the doctor, "Am I

Re: Detailed release notes

2024-09-16 Thread Bruce Momjian
On Mon, Sep 16, 2024 at 03:42:22PM -0300, Marcos Pegoraro wrote: > Em seg., 16 de set. de 2024 às 15:15, Bruce Momjian > escreveu: > > > > I changed the patch to use the section symbol "§" instead of showing > > > the hashes.  The hashes seemed to

Re: Detailed release notes

2024-09-16 Thread Bruce Momjian
On Sat, Sep 14, 2024 at 08:37:31PM -0400, Bruce Momjian wrote: > On Fri, Sep 13, 2024 at 12:39:28PM -0400, Bruce Momjian wrote: > > I applied this patch to PG 17. You can see the results at: > > > > https://momjian.us/pgsql_docs/release-17.html > > > > The c

Re: Detailed release notes

2024-09-14 Thread Bruce Momjian
On Fri, Sep 13, 2024 at 12:39:28PM -0400, Bruce Momjian wrote: > I applied this patch to PG 17. You can see the results at: > > https://momjian.us/pgsql_docs/release-17.html > > The community doc build only shows the master branch, which is PG 18, > and the PG 17 d

Re: Detailed release notes

2024-09-14 Thread Bruce Momjian
On Fri, Sep 13, 2024 at 05:54:31PM -0400, Bruce Momjian wrote: > On Fri, Sep 13, 2024 at 06:41:30PM -0300, Marcos Pegoraro wrote: > > Em sex., 13 de set. de 2024 às 13:39, Bruce Momjian > > escreveu: > > > > I changed the patch to use the section symbol "§

Re: First draft of PG 17 release notes

2024-09-14 Thread Bruce Momjian
have five EXPLAIN items --- that is enough to make a new section, done at: https://momjian.us/pgsql_docs/release-17.html#RELEASE-17-EXPLAIN I don't think I can combine the EXPLAIN items without making them too complex. -- Bruce Momjian https://momjian.us EDB

Re: First draft of PG 17 release notes

2024-09-13 Thread Bruce Momjian
created later. (Justin, Soumyadeep, Michaël) > > In addition, it now accepts the value DEFAULT to reset a previously > set value. (Michaël) I moved the two items next to each other, but I am concerned combining the partition feature with the DEFAULT features is just ma

Re: Detailed release notes

2024-09-13 Thread Bruce Momjian
On Fri, Sep 13, 2024 at 06:41:30PM -0300, Marcos Pegoraro wrote: > Em sex., 13 de set. de 2024 às 13:39, Bruce Momjian > escreveu: > > I changed the patch to use the section symbol "§" instead of showing > the hashes.  The hashes seemed too detailed. 

Re: First draft of PG 17 release notes

2024-09-13 Thread Bruce Momjian
On Wed, Sep 11, 2024 at 09:36:35AM -0500, Nathan Bossart wrote: > On Wed, Sep 11, 2024 at 10:12:58AM -0400, Bruce Momjian wrote: > > On Tue, Sep 10, 2024 at 09:52:42AM -0700, Masahiko Sawada wrote: > >> On Mon, Sep 9, 2024 at 11:29 PM Jelte Fennema-Nio > >> wrote: &

Re: Detailed release notes

2024-09-13 Thread Bruce Momjian
/entities_page.html I think we are limited to the HTML entities listed on that page. I also removed the brackets and the period you added at the end of the text. > there are at least several typos in sgml comment. > like > > > > here should be "possible". Ye

Re: Detailed release notes

2024-09-11 Thread Bruce Momjian
On Wed, Sep 11, 2024 at 10:16:04AM -0400, Bruce Momjian wrote: > On Sat, Sep 7, 2024 at 10:12:00AM +0800, jian he wrote: > > On Sat, Sep 7, 2024 at 6:30 AM Jelte Fennema-Nio wrote: > > > > > > On Thu, 22 Aug 2024 at 21:34, Marcos Pegoraro wrote: > > > >

Re: Detailed release notes

2024-09-11 Thread Bruce Momjian
;s not > > make perfect the enemy of good here. > > > > hi. Thanks for your interest. > patch updated. > > > I have proof-read release-17.sgml again, > making sure the commit url's commit is the same as > release-17.sgml

Re: First draft of PG 17 release notes

2024-09-11 Thread Bruce Momjian
On Tue, Sep 10, 2024 at 09:52:42AM -0700, Masahiko Sawada wrote: > On Mon, Sep 9, 2024 at 11:29 PM Jelte Fennema-Nio wrote: > > > > On Tue, 10 Sept 2024 at 04:47, Bruce Momjian wrote: > > > Yes. There are so many changes at the source code level it is unwise to > &g

Re: First draft of PG 17 release notes

2024-09-11 Thread Bruce Momjian
interesting idea would be to report all function signature changes in each major release in some way. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com When a patient asks the doctor, "Am I going to die?", he means "Am I going to die soon?"

Re: First draft of PG 17 release notes

2024-09-09 Thread Bruce Momjian
On Sat, Sep 7, 2024 at 11:55:09AM +0200, Álvaro Herrera wrote: > On 2024-Sep-05, Bruce Momjian wrote: > > > That seems more infrastructure/extension author stuff which isn't > > normally mentioned in the release notes. I think such people really > > need to lo

Re: First draft of PG 17 release notes

2024-09-05 Thread Bruce Momjian
e/extension author stuff which isn't normally mentioned in the release notes. I think such people really need to look at all the commit messages. -- 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-09-05 Thread Bruce Momjian
ot reverted? see > https://git.postgresql.org/cgit/postgresql.git/commit/?id=3890d90c1508125729ed20038d90513694fc3a7b I don't see them in the PG 17 release notes at: https://www.postgresql.org/docs/17/release-17.html I did just remove the tab complete comment for this though. --

Re: Detailed release notes

2024-08-28 Thread Bruce Momjian
On Wed, Aug 28, 2024 at 10:47:32AM +0200, Peter Eisentraut wrote: > > > > > Change > lock mode output labels (Bruce Momjian) > > > > to > > > > Change > lock mode output labels (Bruce Momjian)

Re: Enable data checksums by default

2024-08-23 Thread Bruce Momjian
uld perhaps be committed separately. I don't think the patch 0003 really > changes the performance penalty. ;-) I think "might" would be more precise than "may" above. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Detailed release notes

2024-08-22 Thread Bruce Momjian
ly? using perl script, and the output is the same as [2] > > > or a popup like this kind of > https://stackoverflow.com/a/47821773/15603477 > but this thread, people seem to want to display the git commit as is, > no need for extra action? Sure, we can display it ho

Re: Partial aggregates pushdown

2024-08-22 Thread Bruce Momjian
On Thu, Aug 22, 2024 at 09:54:02PM +0200, Tomas Vondra wrote: > On 8/22/24 20:56, Bruce Momjian wrote: > > You make a very good point above. Would there ever be cases where a > > targetlist would have multiple aggregates, and some can be pushed down, > > and some have to ret

Re: Partial aggregates pushdown

2024-08-22 Thread Bruce Momjian
val'; oid -- 1186 SELECT oid FROM pg_type WHERE typname = 'int8'; oid - 20 SELECT '1186 20'::oidvector; oidvector --- 1186 20 It seems all four methods could use this

Re: Partial aggregates pushdown

2024-08-22 Thread Bruce Momjian
pes. But I > managed to forget the details :-( > > > WHAT IS NEEDED? > > > > The things needed for this patch are that docs need to be added, and > > detailed codereview needs to be done. > > Yeah, I think the docs are must-have for a proper review. I think the docs are on hold until we decide on a transfer method. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Partial aggregates pushdown

2024-08-22 Thread Bruce Momjian
On Wed, Aug 21, 2024 at 04:59:12PM +0200, Tomas Vondra wrote: > On 8/20/24 20:41, Bruce Momjian wrote: > > SELECT (oid, relname) FROM pg_class LIMIT 1; > > row > > - > > (2619,pg_statistic) > > > > SELECT

Re: Partial aggregates pushdown

2024-08-20 Thread Bruce Momjian
On Tue, Aug 20, 2024 at 07:03:56PM +0200, Jelte Fennema-Nio wrote: > On Tue, 20 Aug 2024 at 18:50, Bruce Momjian wrote: > > Okay, so we can do MAX easily, and AVG if the count can be represented > > as the same data type as the sum? Is that correct? Our only problem is > >

Re: Some questions about PostgreSQL’s design.

2024-08-20 Thread Bruce Momjian
mght find this blog post helpful: https://momjian.us/main/blogs/pgblog/2017.html#June_5_2017 -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Partial aggregates pushdown

2024-08-20 Thread Bruce Momjian
On Tue, Aug 20, 2024 at 10:07:32AM +0200, Jelte Fennema-Nio wrote: > On Thu, 15 Aug 2024 at 23:12, Bruce Momjian wrote: > > Third, I would like to show a more specific example to clarify what is > > being considered above. If we look at MAX(), we can have FDWs return > >

Re: PG docs - Sequence CYCLE clause

2024-08-19 Thread Bruce Momjian
> > > > Please see the attached patch. > > I agree, it makes a bit more sense with your patches. Great, patch applied to master. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Cross-version Compatibility of postgres_fdw

2024-08-19 Thread Bruce Momjian
ht be inconsistent to state only the INSERT > limitation there. Maybe I am too worried about that. I think it is an improvement, so applied to master. Thanks. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Detailed release notes

2024-08-19 Thread Bruce Momjian
the SGML comments don't appear the HTML, so I think we need to write a Perl or shell script to match all the SGML comment text with the HTML text, and insert tooltip text with links for every one of them. Should I work on this? -- Bruce Momjian https://momjian.us EDB

Re: gitmaster server problem?

2024-08-19 Thread Bruce Momjian
gt; > > Guru Meditation: > > > > XID: 1030914118 > > I am not seeing any errors here. nagios monitoring is showing an ipv6 error > though. Not the same issue as yesterday. gitmaster.postgresql.org is working fine for me right now. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: gitmaster server problem?

2024-08-19 Thread Bruce Momjian
g. Okay, thanks for the confirmation. I emailed pginfra at the same time I posted the first email, so they are aware. I have not received a reply from them yet. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Feature Request: Extending PostgreSQL's Identifier Length Limit

2024-08-18 Thread Bruce Momjian
re3Mk9fzZS=9aaa8gfs_n+woa3d...@mail.gmail.com FYI, the COMMENT ON command can help to document identifiers. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

gitmaster server problem?

2024-08-17 Thread Bruce Momjian
EAD Already up to date. Can anyone confirm or report on the cause? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Streaming I/O, vectored I/O (WIP)

2024-08-16 Thread Bruce Momjian
; https://www.postgresql.org/message-id/289a1c0e-8444-4009-a8c2-c2d77ced6f07%40iki.fi Thanks, patch applied to master. -- 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-08-16 Thread Bruce Momjian
> BTW, I was surprised that these were included: > > +2024-02-28 [363eb0599] Convert README to Markdown. > +2024-01-25 [7014c9a4b] Doc: improve documentation for jsonpath behavior. I try to mention significant doc changes, and have done so in the past. -- Bruce Momjian

Re: First draft of PG 17 release notes

2024-08-16 Thread Bruce Momjian
On Fri, Jul 26, 2024 at 01:22:24PM +0900, Yugo Nagata wrote: > I found the following in the release notes: > > Change file boundary handling of two WAL file name functions > (Kyotaro Horiguchi, Andres Freund, Bruce Momjian) > > The functions pg_walfile_name() and pg_w

Re: First draft of PG 17 release notes

2024-08-16 Thread Bruce Momjian
"stxstattarget" column is part of the "pg_statistic_ext" catalog. You are right, fixed in the attached patch. Sorry for the delay. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what

Re: Partial aggregates pushdown

2024-08-15 Thread Bruce Momjian
pg_attribute columns, or we can create a data type with these functions, and assign the data type to pg_aggregate.aggtranstype. Is that accurate? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Partial aggregates pushdown

2024-08-15 Thread Bruce Momjian
On Sun, Jul 7, 2024 at 09:52:27PM +, fujii.y...@df.mitsubishielectric.co.jp wrote: > Hi Bruce. > > > From: Bruce Momjian > > Is there a reason the documentation is no longer a part of this patch? > > Can I help you keep it current? > > Here are the reas

Re: Unknown annotation '-cim' in source code

2024-07-05 Thread Bruce Momjian
arron Taylor 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&t=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

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 >

Re: First draft of PG 17 release notes

2024-07-05 Thread Bruce Momjian
r point. I committed 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
-- different I don't think we can bounce people around to different sections to 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 writ

Re: Partial aggregates pushdown

2024-07-05 Thread Bruce Momjian
ORDER BY 1; > > +ERROR: 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
n >  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
gt; > 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
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 repro

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

2024-06-18 Thread Bruce Momjian
clause 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 m

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
ined 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_docs

Re: Partial aggregates pushdown

2024-06-05 Thread Bruce Momjian
serialize interval_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

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
y 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 > > those supplied

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
t > 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 array match

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
ing all shared statistics 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 po

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 agree k

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 that yo

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 s

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 > > >

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
is better 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) A

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
te) > > > > 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
he same project. Perhaps 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

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
Improve performance when transferring 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, Nazi

Re: First draft of PG 17 release notes

2024-05-22 Thread Bruce Momjian
he most important > 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 re

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 > > faster

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'

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
o rectify this. 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
n just before each commitfest, 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 ti

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
people review commit 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

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/pgsql_docs/re

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://momjian.us/pgsql_docs/r

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

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

  1   2   3   4   5   6   7   8   9   10   >