Hi all,
I have a problem with my query. Query always using parallel bitmap heap scan.
I've created an index with all where conditions and id but query does not this
index and continue to use bitmapscan. So I decided disable bitmap scan for
testing. And after that, things became strange. Cost is
imate of the cost of passing each tuple (row)
from worker to master backend.
Queries written by developer team, I can only recommend them your suggestion.
Gönderen: Tom Lane
Gönderildi: 19 Ekim 2018 Cuma 16:52:04
Kime: Yavuz Selim Sertoglu
Bilg
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-perfor
(actual
time=0.001..0.796 rows=12768 loops=1)
Planning time: 0.909 ms
Execution time: 85.839 ms
shared_buffers is 256G
effective_cache_size is 768G
Database size about 90G
____
Gönderen: Jeff Janes
Gönderildi: 19 Ekim 2018 Cuma 22:40:57
Kime: Yavuz Selim Sertoglu
B
