Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cut index keys results #4702

Closed
kunga opened this issue May 20, 2024 · 0 comments
Closed

Cut index keys results #4702

kunga opened this issue May 20, 2024 · 0 comments
Assignees
@kunga

Comments

@kunga
Copy link
Member

kunga commented May 20, 2024 •
edited

9b7ff42 39b001b 8ea06a8

For one of our production databse with key scheme:

image

We have an impressive memory consumption improvement in 24-1 version:

image

https://nda.ya.ru/t/jeaUjM8p75zVUS

Because almost all the keys now contain only the first column without full urls, index size of the database was reduced by 75% (from 385GB to 93GB)
@kunga kunga self-assigned this May 20, 2024
@kunga kunga changed the title Cut index keys results Cut index keys results post? May 24, 2024
@kunga kunga changed the title Cut index keys results post? Cut index keys results post Jun 3, 2024
@kunga kunga closed this as completed Jun 10, 2024
@kunga kunga changed the title Cut index keys results post Cut index keys results Jun 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kunga kunga

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@kunga