Skip to main content
Question

explain local version: How to understand section "Estimated resources for plan:"

  • September 14, 2023
  • 1 reply
  • 0 views

qihua_wu
Forum|alt.badge.img+1

I have the following info in "Estimated resources for plan:".
Scratch Memory MB: 897
File Handles: 1005
Worker Threads: 24
Blocking Threads: 75
Externalizing Ops: 0
Unbounded Mem Ops: 0
Max Threads: 16

what's the meaning of Unbounded Mem Ops and Externalizing Ops? And there are 3 kinds of threads, what's the relationship among them? Worker Threads,Blocking Threads and Max Threads

1 reply

Sergey_Cherepan_1
Forum|alt.badge.img+2

Great questions!
Not sure why you want to go that deep. Well, except if you want to rewrite Vertica by yourself :-)