dbeaver / dbeaver/cloudbeaver

The database connections are using too much memory.

Open
#3,375 1 comment 1 reaction 1 assignee Claimed by @dariamarutkina View on GitHub
performance x:postgresql xf:metadata
Dominant language
TypeScript
Stars
5.1k
Forks
563
Avg merge
3d 9h
Merged PRs (30d)
59

Description

During my usage, the service encountered an out-of-memory error.

![Image](https://github.com/user-attachments/assets/2203e29f-4593-4ba1-bc51-fb2923735f69)

Upon analyzing the memory, I found three WebSession objects, each occupying over 200 MB of memory.

![Image](https://github.com/user-attachments/assets/8ea5a4e2-4973-49af-bf33-1f13c04a6865)

The TableCache under PostgreSchema contains a large number of PostgreTableRegular objects.

![Image](https://github.com/user-attachments/assets/12c980ac-a03f-4175-b177-8ff1fad3567b)

![Image](https://github.com/user-attachments/assets/313601fc-7025-4250-8b5e-c13120dc50d8)

The PostgreSQL database I am using has over 300,000 tables, views, and other elements.

It appears that each connection loads all the elements in the database, resulting in significant memory consumption.

Is this implementation reasonable? Can it be optimized?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.