Vertica requesting huge memory
We have recently found an issue where Vertica is requesting more amount of memory for queries.
To start with,
this question on this forum explain Verticá's memory management behaviour.
The way vertica handles memory for each query is still an issue for us, but another issue for us why vertica demands more memory for some of our queries.
We have few queries which demand more than 4 GB of memory (I think 4 GB is also too much , but its our budget that gives this memory to our queries.)
The memory asked by Vertica can be anything above normal (9 GB, 45 GB, 78 GB).
We have checked the stats and everything seems to be fine.
Also, is there any document, which explain reading explain verbose more clearly.