You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
After a full sync of my data into the database I can see that stripes are not created efficiently
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
The text was updated successfully, but these errors were encountered:
What's wrong?
After a full sync of my data into the database I can see that stripes are not created efficiently
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
The text was updated successfully, but these errors were encountered: