On Fri, 2021-03-05 at 17:55 +, val.jane...@gmail.com wrote:
> I have a SELECT query that uses a long chain of CTEs (6) and is executed
> repeatedly as part of the transaction (with different parameters). It is
> executed quickly most of the time, but sometimes becomes very slow. I
> managed to
You don't mention shared_buffers, which is quite low by default. Not sure
of the memory of your docker container, but it might be prudent to increase
shared_buffers to keep as much data as possible in memory rather than
needing to read from disk by a second run. To test the possibility Tom Lane
sug
Hi,
I have a quick question, does role custom parameters settings will be granted
to users well?
Does user c_role will have the same settings m_role.CREATE ROLE m_role ;CREATE
ROLE c_role ;ALTER ROLE m_role SET configuration_parameter TO 'VALUE';GRANT
m_role TO c_role;
On Mon, Mar 8, 2021 at 4:30 PM Nagaraj Raj wrote:
> I have a quick question, does role custom parameters settings will be
> granted to users well?
>
Parameters are not inherited - the role credentials that are logging in are
the ones that are used to check for defaults. This "no" is not explici
Thank you for confirmation.
On Monday, March 8, 2021, 03:46:28 PM PST, David G. Johnston
wrote:
On Mon, Mar 8, 2021 at 4:30 PM Nagaraj Raj wrote:
I have a quick question, does role custom parameters settings will be granted
to users well?
Parameters are not inherited - the role cr
