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
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
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;
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
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
