Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector

2023-09-30 Thread Karl O. Pinc
Version 4. Added: v4-0012-Explain-role-management.patch On Mon, 25 Sep 2023 23:37:44 -0500 "Karl O. Pinc" wrote: > > On Mon, 25 Sep 2023 17:55:59 -0500 > > "Karl O. Pinc" wrote: > > > > > On Mon, 25 Sep 2023 14:14:37 +0200 > > > Daniel Gustafsson wrote: > > > > > > Once done you

Doc: Minor update for enable_partitionwise_aggregate

2023-09-30 Thread Andy Atkinson
Hello. While reading the docs for the enable_partitionwise_aggregate parameter on the Query Planning page, I thought the description had a small mistake that could be improved. The current wording is: "which allows grouping or aggregation on a partitioned tables performed separately " Page:

Fix receiving large legal tsvector from binary format

2023-09-30 Thread Ерохин Денис Владимирович
Hello, There is a problem on receiving large tsvector from binary format with getting error "invalid tsvector: maximum total lexeme length exceeded". Required simple steps to reproduce problem: - Make table with one column of type 'tsvector' - Add row with large tsvector (900 Kb will be

Re: Annoying build warnings from latest Apple toolchain

2023-09-30 Thread Andres Freund
Hi, On 2023-09-29 11:11:49 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2023-09-28 22:53:09 -0400, Tom Lane wrote: > >> (Perhaps we should apply the above to HEAD alongside the meson.build fix, > >> to > >> get more test coverage?) > > > The macos animals BF seem to run Ventura, so I

Re: SHARED locks barging behaviour

2023-09-30 Thread Andres Freund
Hi, On 2023-09-30 00:50:11 +0200, Laurenz Albe wrote: > On Fri, 2023-09-29 at 17:45 -0400, Bruce Momjian wrote: > > On Tue, Jan 17, 2023 at 12:18:28PM -0500, Arul Ajmani wrote: > > > I'm trying to better understand the following barging behaviour with > > > SHARED > > > locks. > > ... > > >

Re: Annoying build warnings from latest Apple toolchain

2023-09-30 Thread Andres Freund
Hi, On 2023-09-30 13:28:01 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2023-09-29 12:14:40 -0400, Tom Lane wrote: > >> Looking closer, it's only since v16 that we have export list support > >> on all officially-supported platforms. > > > Oh, right, before that Solaris didn't support

Re: Annoying build warnings from latest Apple toolchain

2023-09-30 Thread Tom Lane
Andres Freund writes: > On 2023-09-29 12:14:40 -0400, Tom Lane wrote: >> Looking closer, it's only since v16 that we have export list support >> on all officially-supported platforms. > Oh, right, before that Solaris didn't support it. I guess we could backpatch > that commit, it's simple

Re: Annoying build warnings from latest Apple toolchain

2023-09-30 Thread Andres Freund
Hi, On 2023-09-29 12:14:40 -0400, Tom Lane wrote: > I wrote: > > Andres Freund writes: > >> On 2023-09-28 16:46:08 -0400, Tom Lane wrote: > >>> Well, it's only important on platforms where we can't restrict > >>> libpq.so from exporting all symbols. I don't know how close we are > >>> to

Re: Eliminate redundant tuple visibility check in vacuum

2023-09-30 Thread Andres Freund
Hi, On 2023-09-28 11:25:04 -0400, Robert Haas wrote: > I went ahead and committed 0001. If Andres still wants to push for > more renaming there, that can be a follow-up patch. Agreed. > And we can see if he or anyone else has any comments on this new version of > 0002. To me we're down into the

Re: [feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns

2023-09-30 Thread Andrew Dunstan
On 2023-07-31 Mo 20:46, Zhang Mingli wrote: On Aug 1, 2023, at 03:35, Andrew Dunstan wrote: I was hoping it be able to get to it today but that's not happening. If you want to submit a revised patch as above that will be good. I hope to get to it later this week. HI, Andrew Patch

Re: Remove ParallelReadyList and worker_spi_state from typedefs.list

2023-09-30 Thread Tom Lane
vignesh C writes: > Remove ParallelReadyList and worker_spi_state from typedefs.list, > these structures have been removed as part of an earlier commits, > ParallelReadyList was removed as part of > 9bfd44bbde4261181bf94738f3b041c629c65a7e. worker_spi_state was removed > as part of

Remove ParallelReadyList and worker_spi_state from typedefs.list

2023-09-30 Thread vignesh C
Hi, Remove ParallelReadyList and worker_spi_state from typedefs.list, these structures have been removed as part of an earlier commits, ParallelReadyList was removed as part of 9bfd44bbde4261181bf94738f3b041c629c65a7e. worker_spi_state was removed as part of

Re: bug: ANALYZE progress report with inheritance tables

2023-09-30 Thread Heikki Linnakangas
On 28/09/2023 19:06, Heikki Linnakangas wrote: On 22/01/2023 18:23, Justin Pryzby wrote: pg_stat_progress_analyze was added in v13 (a166d408e). For tables with inheritance children, do_analyze_rel() and acquire_sample_rows() are called twice. The first time through,

Re: commitfest app down for repairs

2023-09-30 Thread Joe Conway
On 9/30/23 08:47, Joe Conway wrote: The committfest app is down for repairs. We will reply back here once it is back up. The commitfest app is back up. We restored to a backup from one day prior. We will take a look at what changed in between, but it might be up to folks to redo some things.

commitfest app down for repairs

2023-09-30 Thread Joe Conway
The committfest app is down for repairs. We will reply back here once it is back up. -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com

Re: On login trigger: take three

2023-09-30 Thread Alexander Korotkov
On Fri, Sep 29, 2023 at 1:15 PM Daniel Gustafsson wrote: > > On 28 Sep 2023, at 23:50, Alexander Korotkov wrote: > > > I don't think I can reproduce the performance regression pointed out > > by Pavel Stehule [1]. > > > I can't confirm the measurable overhead. > > > Running the same pgbench