回复: [External] Re: PG 10 experience different user execute same sql get different access plan

, 100085 -邮件原件- 发件人: Tom Lane 发送时间: 2021年5月19日 23:00 收件人: Zhiyu ZY13 Xu 抄送: pgsql-general@lists.postgresql.org 主题: [External] Re: PG 10 experience different user execute same sql get different access plan Zhiyu ZY13 Xu writes: > I experience a PG optimizer problem. Different u

Re: PG 10 experience different user execute same sql get different access plan

Zhiyu ZY13 Xu writes: > I experience a PG optimizer problem. Different user query with same SQL at > same time. But get different access plan. If you've got row-level security turned on for that table, it could explain results like this. RLS limits the planner's ability to see statistics, whi

PG 10 experience different user execute same sql get different access plan

Hi Admin support I experience a PG optimizer problem. Different user query with same SQL at same time. But get different access plan. On the test env: PG 10.3 env. User: ccfuser. This user is DB owner. It will get result within 3 second. The totally cost is : 99672 User: a_ap