Re: change the default value of enable_bitmapscan to off

2023-01-14 Thread Tom Lane
"hehaoc...@hotmail.com" writes: > The default is enable_bitmapscan on. However, TPC-H.query17 get slower > running on my NVMe SSD (WD SN850) after switching on the parameter: latency > drop from 9secs to 16secs. During a B-tree Index Scan, bitmapscan > optimization converts random I/O into sequ

Re: change the default value of enable_bitmapscan to off

2023-01-14 Thread Pavel Stehule
Hi so 14. 1. 2023 v 15:51 odesílatel hehaoc...@hotmail.com < hehaoc...@hotmail.com> napsal: > The default is enable_bitmapscan on. However, TPC-H.query17 get slower > running on my NVMe SSD (WD SN850) after switching on the parameter: latency > drop from 9secs to 16secs. During a B-tree Index Sc