Tue, Jan 26, 2021 at 9:05 PM Tom Lane wrote:
> Wenjun Che writes:
> > We are running pg 10.10 on AWS RDS. I want to increase work_mem for one
> > user with following command:
> > ALTER ROLE test_user SET work_mem TO '50 MB';
> > After I run the command and
Hello
We are running pg 10.10 on AWS RDS. I want to increase work_mem for one
user with following command:
ALTER ROLE test_user SET work_mem TO '50 MB';
After I run the command and log in as test_user, "show work_mem" still
shows the default 4MB.
Thank you
Sat, Jun 6, 2020 at 11:24 PM Wenjun Che wrote:
>
>> Hi
>>
>> I am testing full vacuum with pg 10.10 on AWS RDS. I noticed for some
>> tables, the number of waste bytes stays at a few MB after I run full
>> vacuum. I double-checked that there are no long running tr
Hi
I am testing full vacuum with pg 10.10 on AWS RDS. I noticed for some
tables, the number of waste bytes stays at a few MB after I run full
vacuum. I double-checked that there are no long running transactions, no
orphaned prepared transactions and no abandoned replication slots.
Here is outpu
