On 8/21/25 09:29, Dominique Devienne wrote:
On Thu, Aug 21, 2025 at 6:00 PM Karsten Hilbert wrote:
Am Thu, Aug 21, 2025 at 08:46:00AM -0700 schrieb Adrian Klaver:
https://rhaas.blogspot.com/2023/01/surviving-without-superuser-coming-to.html
Thanks, I did, but did not find the answer to: Is t
On 8/21/25 09:51, hubert depesz lubaczewski wrote:
On Thu, Aug 21, 2025 at 08:59:03AM -0700, Adrian Klaver wrote:
Getting to the bottom of the bag of ideas:
Have you looked at the OS system log for the time period involved?
Yes. Mostly dmesg. Nothing interesting logged around the time.
You m
Dear all,
PG 17 documentation says that using "WITH ADMIN" allows the
role being added to another group role to grant/revoke
membership in said group to other roles.
Does this imply that an ADMIN role _must_ itself be a member
of the group role it is to maintain membership of ?
The question aris
On 8/21/25 08:36, Karsten Hilbert wrote:
Dear all,
PG 17 documentation says that using "WITH ADMIN" allows the
role being added to another group role to grant/revoke
membership in said group to other roles.
I would start by reading this:
https://rhaas.blogspot.com/2023/01/surviving-without-su
Am Thu, Aug 21, 2025 at 09:11:57AM -0700 schrieb David G. Johnston:
> > Thanks, I did, but did not find the answer to: Is there a
> > way for a role that can manage membership in a group role to
> > not itself be a member of that group role ?
>
> A superuser can do this. Otherwise, no. In order
If all your queries are coming through pgBouncer, and only those hang (the
server itself responds if you connect directly to it), then it might be
this pgBouncer issue:
https://github.com/pgbouncer/pgbouncer/issues/1054
Although that issue is now "closed", because the invisible "debug" log
messag
On 8/21/25 03:07, hubert depesz lubaczewski wrote:
On Wed, Aug 20, 2025 at 10:45:13AM -0700, Adrian Klaver wrote:
On 8/20/25 09:08, hubert depesz lubaczewski wrote:
On Wed, Aug 20, 2025 at 08:14:47AM -0700, Adrian Klaver wrote:
Hmm.
From initial post:
"For ~ 1 second there are no logs goin
Am Thu, Aug 21, 2025 at 06:29:36PM +0200 schrieb Dominique Devienne:
> > Thanks, I did, but did not find the answer to: Is there a
> > way for a role that can manage membership in a group role to
> > not itself be a member of that group role ?
>
> Yes and no. Depends what you mean by MEMBER...
..
On Thu, Aug 21, 2025 at 2:11 AM Dominique Devienne wrote:
> On Wed, Aug 20, 2025 at 7:37 PM Florents Tselai
> wrote:
> > > On 20 Aug 2025, at 7:47 AM, Ertan Küçükoglu
> > > wrote:
> > > I would like to learn if there is any benefit of using domains over data
> > > types for table column defini
On Thu, Aug 21, 2025 at 6:37 PM Karsten Hilbert wrote:
> Am Thu, Aug 21, 2025 at 06:29:36PM +0200 schrieb Dominique Devienne:
> > > Thanks, I did, but did not find the answer to: Is there a
> > > way for a role that can manage membership in a group role to
> > > not itself be a member of that grou
On Thu, Aug 21, 2025 at 08:59:03AM -0700, Adrian Klaver wrote:
> Getting to the bottom of the bag of ideas:
> Have you looked at the OS system log for the time period involved?
Yes. Mostly dmesg. Nothing interesting logged around the time.
> You mentioned this seemed to involve PREPARE and DISCAR
On Thu, Aug 21, 2025 at 6:00 PM Karsten Hilbert wrote:
> Am Thu, Aug 21, 2025 at 08:46:00AM -0700 schrieb Adrian Klaver:
> > https://rhaas.blogspot.com/2023/01/surviving-without-superuser-coming-to.html
>
> Thanks, I did, but did not find the answer to: Is there a
> way for a role that can manage
On Thursday, August 21, 2025, Karsten Hilbert
wrote:
> Am Thu, Aug 21, 2025 at 08:46:00AM -0700 schrieb Adrian Klaver:
>
> > >PG 17 documentation says that using "WITH ADMIN" allows the
> > >role being added to another group role to grant/revoke
> > >membership in said group to other roles.
> >
>
Am Thu, Aug 21, 2025 at 08:46:00AM -0700 schrieb Adrian Klaver:
> >PG 17 documentation says that using "WITH ADMIN" allows the
> >role being added to another group role to grant/revoke
> >membership in said group to other roles.
>
> I would start by reading this:
>
> https://rhaas.blogspot.com/2
On 8/21/25 08:13, hubert depesz lubaczewski wrote:
On Thu, Aug 21, 2025 at 08:04:25AM -0700, Adrian Klaver wrote:
By bouncer I assume you mean something like pgBouncer, a connection pooler.
Is it possible to determine what bouncer the queries in question are coming
from?
From the POV of db,
On Thu, Aug 21, 2025 at 08:04:25AM -0700, Adrian Klaver wrote:
> > > > > "For ~ 1 second there are no logs going to log (we usually have at
> > > > > 5-20
> > > > > messages logged per second), no connection, nothing. And then we get
> > > > > bunch (30+) messages with the same milisecond time."
>
On Thu, Aug 21, 2025 at 12:41:44PM +0100, Thom Brown wrote:
> Ah, yeah I meant transparent hugepage:
> cat /sys/kernel/mm/transparent_hugepage/enabled
> This should show it being set as "never".
Ah. Sorry, couldn't decipher. Yes, it's "never".
> > # grep -oP '^2025-08-19 22:09:2\d\.\d+ UTC'
> >
On Thu, 21 Aug 2025 at 11:03, hubert depesz lubaczewski
wrote:
>
> On Wed, Aug 20, 2025 at 06:30:00PM +0100, Thom Brown wrote:
> > Do you have THP enabled? Can you use mpstat and see what %steal shows as?
>
> Sorry, what is "THP"? I tried searching for "what is thp", and most
> common search resul
On Wed, Aug 20, 2025 at 10:45:13AM -0700, Adrian Klaver wrote:
> On 8/20/25 09:08, hubert depesz lubaczewski wrote:
> > On Wed, Aug 20, 2025 at 08:14:47AM -0700, Adrian Klaver wrote:
> > > Hmm.
> > >
> > > From initial post:
> > >
> > > "For ~ 1 second there are no logs going to log (we usually
On Wed, Aug 20, 2025 at 06:30:00PM +0100, Thom Brown wrote:
> Do you have THP enabled? Can you use mpstat and see what %steal shows as?
Sorry, what is "THP"? I tried searching for "what is thp", and most
common search results are related to some chemical compound.
mpstat, yes, we have it. Let me
On Wed, Aug 20, 2025 at 11:24:29AM -0600, Rob Sargent wrote:
> > On Wed, Aug 20, 2025 at 08:14:47AM -0700, Adrian Klaver wrote:
> >> Hmm.
> >>
> >> From initial post:
> >>
> >> "For ~ 1 second there are no logs going to log (we usually have at 5-20
> >> messages logged per second), no connection,
On Wed, Aug 20, 2025 at 7:37 PM Florents Tselai
wrote:
> > On 20 Aug 2025, at 7:47 AM, Ertan Küçükoglu
> > wrote:
> > I would like to learn if there is any benefit of using domains over data
> > types for table column definitions in terms of performance gain/loss.
> I know that this doesn’t a
22 matches
Mail list logo
