All Questions
Tagged with database-partitioning database
80 questions
0
votes
1
answer
36
views
Is partitioning the correct feature for periodical deletions in large tables?
If I have two tables in a (Oracle) database that keeps an history of records through time :
CREATE TABLE Records(
RecordPackId NUMBER,
RecordId NUMBER,
Data VARCHAR2(4000),
PRIMARY KEY ...
- 319
0
votes
1
answer
329
views
For a table partitioning (by date) scenario seems I have to add the date column to the PK - but doesn't this devalue the PK?
I want to partition a large table that currently has an appropriate column as the primary key.
We want to, on a regular basis, remove older rows via partition switching.
The table has a date column ...
0
votes
0
answers
132
views
MySQL Partition table based on two columns
I have an events table which holds historical data of 10 year's with daily coming new data. Now the total rows in this table are 22560041.
Table has column's id, title, status (1-4), start_date and I ...
0
votes
1
answer
268
views
Postgres: Identifying partitions older than N days to drop them
I have a table partitioned by a timestamp field in a postgres database (v 13.11). I create new partitions every day. How do I look for partitions older than N days so I can drop then?
CREATE TABLE ...
- 81
2
votes
1
answer
311
views
Using PostgreSQL table as tumbling window persistence layer
Currently, I'm storing a large amount of time-series data into the following PostgreSQL table:
create table view (
user_id uuid,
product_id integer,
banner_id integer,
campaign_id integer,
...
- 7,044
0
votes
0
answers
481
views
Partitioning existing tables using PostgreSQL 13
I'm using PostgreSQL 13.8 and i have a lot of big tables (with a lot of records) and queries are spending too much. I though it's a good idea to partition some tables to speed them up. But i'm totally ...
0
votes
1
answer
125
views
Why Partition Scan is not happening
I have partitioned my table using day column defined as this in schema : day DATE
No i am running this query :
select * from my_table where day={d '2023-06-07'}
My Query Plan is showing me this :
...
- 539
1
vote
1
answer
721
views
Truncate partition doesn't throw an error when the partition range is lower than base partition oracle
I have a table partitioned based on the year and month (eg:202001).
Let's say the oldest data available is for partition 201304 and the latest available is for 202001.What I observed was when we ...
- 11
0
votes
1
answer
1k
views
How do I partition mongodb datasets?
I'm stuck in mongodb sharding and I need your help!
My first question is "How do I make my database partitioned:true in sh.status()?
I've worked with sharding servers and mongos but I need to ...
0
votes
0
answers
188
views
Could not drop the last static partition in Oracle table
I have a table with the statically created partitions by range, monthly based:
...
PARTITION BY RANGE (expiration_time) INTERVAL (NUMTOYMINTERVAL(1, 'month')) (
PARTITION p_2021_10 VALUES LESS THAN (...
- 1
0
votes
0
answers
144
views
Get row with max timestamp value before a date in partitioned table without scanning all partitions
I've created a partitioned table to store measurement data associated with a timestamp and then ranged partitions for each year. I also created an index on the field with the timestamp.
CREATE TABLE ...
- 1
0
votes
1
answer
98
views
Oracle DB: Portioning delete with Automation
I'm new to work with database. Describing the Problem below:
Problem: Having 'X' number of Tables with 'Y' number of partitions. Now want to have a way of finding which tables have partitions and ...
- 11
0
votes
1
answer
730
views
How Drop the only subpartition of a partition
While I am deleting subpartitions, one of the partition contains only one subpartition I got an error.
Error: ORA-14629 cannot drop the only subpartition of a partition
Can anyone know how to drop ...
- 45
1
vote
2
answers
49
views
SQL result dense Rank in revolving group pattern
Say I have a table like
store
date
is_open
Bay
1/1/2022
true
Bay
1/2/2022
true
Bay
1/3/2022
true
Bay
1/4/2022
false
Bay
1/5/2022
false
Bay
1/6/2022
false
Bay
1/7/2022
true
Bay
1/8/2022
true
Bay
1/9/...
- 5,729
0
votes
0
answers
230
views
dropping partition in MySQL?
I am kinda lame in mysql, but I need it for running Zabbix.
Due to large DB, I am using a partitioning, based on script below.
https://bestmonitoringtools.com/zabbix-partitioning-tables-on-mysql-...
- 1