connects - Search results

Mailing lists  >>  pgsql-performance  >>  Thread

2024-04-21 11:08:11 | Re: Extremely slow to establish connection when user has a high number of roles (Michal Charemza)

CONNECT privilege? Running `select * from pg_hba_file_rules` it looks like the user column

Mailing lists  >>  pgsql-performance  >>  Thread

2024-04-20 15:52:47 | Re: Extremely slow to establish connection when user has a high number of roles (Tom Lane)

connect? Well, it's going to be looking to see that the user has CONNECT

Mailing lists  >>  pgsql-performance  >>  Thread

2024-04-20 15:34:12 | Re: Extremely slow to establish connection when user has a high number of roles (Michal Charemza)

connected yet after the restart? A user that hasn't connected yet would be much

Mailing lists  >>  pgsql-performance  >>  Thread

2024-04-20 15:12:56 | Re: Extremely slow to establish connection when user has a high number of roles (Michal Charemza)

connect. We've since changed that to one role, and that user connects fine now. helpful

Mailing lists  >>  pgsql-performance  >>  Thread

2024-04-20 11:55:12 | Extremely slow to establish connection when user has a high number of roles (Michal Charemza)

connecting user (the one that grants connection permissions), connecting is always virtually instantaneous. The closest