The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

"memory_inuse_kb" of 'general' resource pool keeps increasing

I am experiencing a strange issue: at a fresh start of the database, the 'general' resource pool has about 50 GB of memory per node. After running some queries, parts of the acquired memory are never reclaimed and therefore "memory_inuse_kb" keeps increasing. It increases to as much as 30 GB when I am forced to restart the database.

There are no active resource acquisitions, and yet "memory_inuse_kb" is not going down. Version is Vertica Analytic Database v9.2.0-0.

Answers

  • SruthiASruthiA Employee

    Did the queries finish execution successfully? Are there any sessions active pertaining to those queries?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.