Ynt: Gained %20 performance after disabling bitmapscan

2018-10-21 Thread Yavuz Selim Sertoglu
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

Ynt: Gained %20 performance after disabling bitmapscan

2018-10-21 Thread Yavuz Selim Sertoglu
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