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

qihua_wuqihua_wu ✭
in General Discussion

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

Answers

  • Sergey_Cherepan_1Sergey_Cherepan_1 ✭✭✭

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...