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

2021-05-19 Thread Zhiyu ZY13 Xu
, 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

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

2021-05-19 Thread Zhiyu ZY13 Xu
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