512426 | | || | | |
| 245/1163 | 15932 | AccessExclusiveLock | f | f
(1 row)
From: Tom Lane
Date: Thursday, August 24, 2023 at 3:02 PM
To: Hellen Jiang
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Materialized view refr
materialized view refreshing problem?
Thanks
Hellen Jiang
23, 2023 at 1:57 PM
To: Hellen Jiang ,
pgsql-general@lists.postgresql.org
Subject: Re: Read only user permission
> On 23/08/2023 18:42 CEST Hellen Jiang wrote:
>
> I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have acces
Hi,
I have created readonly and readwrite roles with the following grants: however,
readonly user does not have access to the new tables created by readwrite user.
(readonly user has the access to new tables created by admin).
Any idea how I can grant the access to readonly to make sure it has t
Hi,
I am going to upgrade our production database( postgresql 12.10) to postgresql
15.3.
After upgrade to 15.3, Do you have to do re-index?
If I have to do re-index, can I only do re-index on some partitioned tables?
We have a lot of big tables which are partitioned by date, for example, table1
