Skip to content

Resolve Database Performance Issues #317

@artntek

Description

@artntek

After deploying to production, evaluate performance to see if it has improved over the dev cluster performance.

Try using SSDs with ceph as the CNPG storage layer.

Also look at tuning postgres settings and memory usage, and in particular, look for ways to make postgres use memory for temp tables, instead of writing to disk. (Some of the slower queries also involve writes to temp tables)

Sub-issues

Metadata

Metadata

Assignees

Labels

D-2.2Deployed and refactored, open-source VegBank

Type

Projects

Status

Ready

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions