Thanks for the reply Jeff,
I know 20ms is nothing but it shows me that there is a problem with my
configuration. I want to find it.
I've vacuumed table but it didn't work either.
After vacuum, query start to using another index.
I run query a few times so result comes from cache with both query
Thanks for the reply Vladimir,
I thought explain analyze is enough. I run vacuum analyze manually but it
didn't work either.
Gönderen: Vladimir Ryabtsev
Gönderildi: 19 Ekim 2018 Cuma 21:09:03
Kime: Yavuz Selim Sertoglu
Bilgi: pgsql-performance@lists.postgresql.o
Thanks for reply Tom,
AFAIK nothing changed with planner. Only max_parallel_*
[postgres@db-server ~]$ psql -c"show all" | grep parallel
force_parallel_mode | off
| Forces use of parallel query facilities.
max_parallel_workers
