Re: New committers: Melanie Plageman, Richard Guo

2024-04-26 Thread Roberto Mello
On Fri, Apr 26, 2024 at 5:54 AM Jonathan S. Katz wrote: > The Core Team would like to extend our congratulations to Melanie > Plageman and Richard Guo, who have accepted invitations to become our > newest PostgreSQL committers. > > Please join us in wishing them much success and few reverts! >

Re: An improved README experience for PostgreSQL

2024-03-21 Thread Roberto Mello
On Wed, Feb 28, 2024 at 11:55 AM David E. Wheeler wrote: > > IME the keys to decent-looking Markdown are: > > 1. Wrapping lines to a legible width (76-80 chars) > 2. Link references rather than inline links +1 on Markdown including David's suggestions above. Agree that without proper

Re: documentation structure

2024-03-18 Thread Roberto Mello
On Mon, Mar 18, 2024 at 10:12 AM Robert Haas wrote: > I was looking at the documentation index this morning[1], and I can't > help feeling like there are some parts of it that are over-emphasized > and some parts that are under-emphasized. I'm not sure what we can do > about this exactly, but I

Re: [DOC] Add detail regarding resource consumption wrt max_connections

2024-01-13 Thread Roberto Mello
On Fri, Jan 12, 2024 at 3:15 PM Cary Huang wrote: > I think it is good to warn the user about the increased allocation of > memory for certain parameters so that they do not abuse it by setting it to > a huge number without knowing the consequences. > > It is true that max_connections can

Re: Add minimal C example and SQL registration example for custom table access methods.

2023-11-15 Thread Roberto Mello
Suggestion: In the C example you added you mention in the comment: + /* Methods from TableAmRoutine omitted from example, but all + non-optional ones must be provided here. */ Perhaps you could provide a "see " to point the reader finding your example where he could find these

[DOC] Add detail regarding resource consumption wrt max_connections

2023-11-13 Thread Roberto Mello
allocation of those resources, including shared memory. Sincerely, Roberto Mello max-connections-guc-detail.patch Description: Binary data

Re: Requiring recovery.signal or standby.signal when recovering with a backup_label

2023-10-30 Thread Roberto Mello
On Mon, Oct 30, 2023 at 1:09 AM Michael Paquier wrote: > > I have been reviewing the patch, and applied portions of it as of > dc5bd388 and 1ffdc03c and they're quite independent pieces. After > that, the remaining bits of the patch to change the behavior is now > straight-forward. I have

Re: PG 16 draft release notes ready

2023-06-27 Thread Roberto Mello
Adding to this thread as suggested by jkatz for consideration of adding to release notes... In [1] I mention the omission of ldap_password_hook and a suggested paragraph. Roberto [1] https://www.postgresql.org/message-id/CAKz%3D%3DbLzGb-9O294AoZHqEWpAi2Ki58yCr4gaqg1HnZyh3L1uA%40mail.gmail.com

Re: PostgreSQL 16 Beta 2 release announcement draft

2023-06-27 Thread Roberto Mello
On Tue, Jun 27, 2023 at 11:40 AM Jonathan S. Katz wrote: > > Was this discussed on the release notes thread?[1]. It can always be > added to the release notes -- those aren't finalized until GA. > > After Beta 1, the announcements are either about new feature > additions/removals since the last

Re: PostgreSQL 16 Beta 2 release announcement draft

2023-06-27 Thread Roberto Mello
On Tue, Jun 27, 2023 at 8:32 AM Jonathan S. Katz wrote: > > I used the open items list[1] to build the draft. If there are any > notable please omissions, please let me know. I noticed that ldap_password_hook [1] was omitted from the release notes. I believe it should be included if nothing else

Re: Postgres Version want to update from 9.2 to 9.5 version in CentOS 7.9

2023-04-28 Thread Roberto Mello
On Fri, Apr 28, 2023 at 12:10 PM Gautham Raj wrote: > Thank you for the quick response. > > Yes, I'm willing to get the latest version. I read some articles CentOS 7 > doesn't support the latest versions. So was trying the old versions. > > I tried the article shared but, got the below error at

Re: PostgreSQL 16 Release Management Team & Feature Freeze

2023-03-21 Thread Roberto Mello
On Tue, Mar 21, 2023 at 9:35 AM Jonathan S. Katz wrote: > > You can track open items for the PostgreSQL 16 release here: > > https://wiki.postgresql.org/wiki/PostgreSQL_16_Open_Items The wiki page references April 8th, 2022, btw. Roberto

Re: doc: BRIN indexes and autosummarize

2022-07-05 Thread Roberto Mello
On Tue, Jul 5, 2022 at 5:47 AM Alvaro Herrera wrote: > OK, I have adopted all your proposed changes, thanks for submitting in > both forms. I did some more wordsmithing and pushed, to branches 12 and > up. 11 fails 'make check', I think for lack of Docbook id tags, and I > didn't want to waste

Re: doc: BRIN indexes and autosummarize

2022-07-05 Thread Roberto Mello
On Mon, Jul 4, 2022 at 9:20 AM Alvaro Herrera wrote: > > [Some of] these additions are wrong actually. It says that autovacuum > will not summarize new entries; but it does. If you just let the table > sit idle, any autovacuum run that cleans the table will also summarize > any ranges that

Re: Patch proposal: New hooks in the connection path

2022-07-01 Thread Roberto Mello
On Fri, Jul 1, 2022 at 5:00 PM Nathan Bossart wrote: > > > That being said, I don't see why this information couldn't be provided in a > system view. IMO it is generically useful. +1 for a system view with appropriate permissions, in addition to the hooks. That would make the information

doc: BRIN indexes and autosummarize

2022-06-28 Thread Roberto Mello
Here's a patch to clarify the BRIN indexes documentation, particularly with regards to autosummarize, vacuum and autovacuum. It basically breaks down a big blob of a paragraph into multiple paragraphs for clarity, plus explicitly tells how summarization happens manually or automatically. I also

Re: pgcon unconference / impact of block size on performance

2022-06-04 Thread Roberto Mello
On Sat, Jun 4, 2022 at 5:23 PM Tomas Vondra wrote: > Hi, > > At on of the pgcon unconference sessions a couple days ago, I presented > a bunch of benchmark results comparing performance with different > data/WAL block size. Most of the OLTP results showed significant gains > (up to 50%) with

Re: "an SQL" vs. "a SQL"

2021-06-10 Thread Roberto Mello
On Thu, Jun 10, 2021 at 1:27 AM David Rowley wrote: > > I think we should change all 55 instances of "a SQL" in the docs to > use "an SQL" and leave the 800 other instances of "a SQL" alone. +1 Consistency is good. Roberto