I Have a mysql(v8.x) table with 4 Billion records and I need to partition on one of the varchar column. Partition on date column or integer column doesn't work in this case. This is a unique usecase. Partitioning will be…
We are using Mysql EntityMapping table with 140cr rows, each entity mapped with 1 or 2 million contacts rows, it is growing in last 5 months. The table contains PK, entityId (Index column), contactId (index column), Added time(index column), remaining…
I am trying to add partitioning to a table in my database. Here is an example: CREATE TABLE IF NOT EXISTS myBd.test_table ( id SERIAL PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT NOT NULL ) PARTITION BY hash (id);…
We are trying to optimize a query to a partitioned table, the query looks something like this: SELECT col1, col2 FROM partitioned_table WHERE profile_id = '00000000-0000-0000-0000-000000000000' AND product_id = 'product_a' ORDER BY created_at DESC LIMIT 500; Parent/partitioned table definition: CREATE…
I would like to get the result in mongodb similar to partitioning in postgresql. That is, I want that on one instance of the database, without a cluster, without additional nodes, the data is distributed, for example, by date, and…
I have huge words table which I'm running LIKE query on: create table words ( id int, word varchar ) It works pretty long. Index doesn't help a lot, so I'm trying to partition it by word column: create table…
Would be glad if you could help me out: Got a query that is supposed to take some task from the database (Postgres) partitioned table (partitioned by execute_ts) and take them to work thread-safely (with several workers in the service…
Column Definitions The ID column is the primary key with auto-increment that we use to maintain the pool range. Serial is unique and needs to be unique even after partitioning. The status of a product is an enum with a…
I've got a dataset (in postgres specifically) that I need to calculate the 'user session time' for. I'm fairly positive I need to use partitioning to answer the question, but I'm not really sure how to go about it. The…
I have a table that contains a month and a year column. I have a query which usually looks something like WHERE month=1 AND year=2022 Given how large this table is i would like to make it more efficient using…