is there still a memory leak with hash joins in PG 12.11 ?

Hi, We are running on PG 12.11. We recognized an evergrowing memory usage. work_mem = 50M there are some regularly hash joins. I found this blog post talking about a memory leak having hash joins due to a larger work_mem. https://gist.github.com/luhn/2b35a9b31255e3a6a2e6a06d1213dfc9 Does anyon

Re: is there still a memory leak with hash joins in PG 12.11 ?

On 2022-Sep-28, Zwettler Markus (OIZ) wrote: > I found this blog post talking about a memory leak having hash joins due to a > larger work_mem. > https://gist.github.com/luhn/2b35a9b31255e3a6a2e6a06d1213dfc9 Oh dear, is that what passes for a blog post these days? > Does anyone know if this pro

Streaming wal from primiry terminating

Hi, After failover all stand by nodes could not start streaming wal recovery. Streaming recovery start from 1473/A500, but standby start at 1473/A5FFEE08, this seems to be the problem. What can we do in this case to restore? Is it possible to shift wal streaming recovery point on primary? Can

table inheritance and privileges

I'm dynamically creating tables that inherit from another table but they don't inherit the access privileges. Is there a way to have the new tables inherit their parent tables access privileges? Ted

Re: Limiting the operations that client-side code can perform upon its database backend's artifacts

On 2022-09-28 09:13:53 +0800, Julien Rouhaud wrote: > On Tue, Sep 27, 2022 at 05:27:22PM -0700, Bryn Llewellyn wrote: > > > hjp-pg...@hjp.at wrote: > > >> rjuju...@gmail.com wrote: > > >>> b...@yugabyte.com wrote: > > >>> My demo seems to show that when a program connects as "client", it can > > >>

Re: table inheritance and privileges

Ted Toth writes: > I'm dynamically creating tables that inherit from another table but > they don't inherit the access privileges. Is there a way to have the > new tables inherit their parent tables access privileges? No, but do you need that? When accessing the parent table, there's no need for

Re: Limiting the operations that client-side code can perform upon its database backend's artifacts

On 2022-09-27 19:29:39 -0700, Bryn Llewellyn wrote: > I interpreted what Tom wrote to mean that he flatly rejected the idea > that a database design was possible that prevented a client session > that authorized as a role, that's designed for that purpose, from > dropping tables and otherwise arbit

Re: table inheritance and privileges

I have written a 'before insert' trigger using a similar technique to that described in section 5.11.3 of : https://www.postgresql.org/docs/14/ddl-partitioning.html#DDL-PARTITIONING-USING-INHERITANCE However my trigger queries to see if the partition table exists, creates it if it doesn't then ins

Re: Streaming wal from primiry terminating

At Wed, 28 Sep 2022 08:50:12 +, "Lahnov, Igor" wrote in > Hi, > After failover all stand by nodes could not start streaming wal recovery. > Streaming recovery start from 1473/A500, but standby start at > 1473/A5FFEE08, this seems to be the problem. It's not a problem at all. It is quit