hydradatabase / hydradatabase/columnar

[Bug]: Stripe optimization not working efficiently

Open
#239 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
C
Stars
3k
Forks
106
PR merge metrics
No merged PRs in 30d

Description

### What's wrong?

After a full sync of my data into the database I can see that stripes are not created efficiently

![image](https://github.com/hydradatabase/hydra/assets/3295086/9e7ae90f-d313-487f-b820-a2265e2c5798)

In the image shared above you can see stripes containing 75 items and others that contain 80k+.
as I can understand default value is 150k+ per stripe.

I understand that you can run vacuum full for the table but this wont work for Real-Time inserts. Our system inserts (1-100 items every minute). So for each insert there will be a stripe from what I understand. IN 7 days this will create a total mess in the database

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.