"[email protected]" 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
Hi
so 14. 1. 2023 v 15:51 odesÃlatel [email protected] <
[email protected]> 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
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 sequential. However, many users use SSDs rath
