All Questions
14 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
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
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
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
1
vote
2
answers
3k
views
Why select result takes long time in partitioned table in postgreSql?
I have a daily partitioned table in postgresql. It uses cdr_date for partitioning. When I select a simple query, it takes a long time I dont know why!
this is a simple sql
EXPLAIN (ANALYZE , BUFFERS ...
- 27
2
votes
1
answer
353
views
Why Oracle database requires to provide at least single partition when creating partition by interval
I wonder why Oracle Databases require that at least single partition is defined when creating PARTITION BY RANGE INTERVAL
This is correct:
CREATE TABLE FOO (
bar VARCHAR2(10),
creation_date ...
- 512
0
votes
1
answer
614
views
does database partitioning require changes in application code?
I have an application written in Spring-boot , we have done with the optimization of the queries. We are thinking of database (Oracle database ) partitioning based on date. do we need to do any ...
- 695
0
votes
0
answers
345
views
Database partition - Better done by PHP or MySQL?
Let me explain the context first : I am building a visit tracker, with PHP and MySQL. So when a user visit a certain URL, his informations will be registered, then he will be redirected to a page. ...
- 291
0
votes
2
answers
663
views
Mysql partition - How to do list partitioning of a table that contains unique column?
I am doing mysql list partitioning. my table data is as below
----------------------------------------
id | unique_token | city | student_name |
----------------------------------------
1 | xyz ...
- 1,087
0
votes
2
answers
207
views
MySQL partitioning by table rows
I create a table as below
CREATE TABLE `Archive_MasterLog` (
`LogID` INT(10) NOT NULL AUTO_INCREMENT,
`LogDate` DATETIME NULL,
`AssessorName` VARCHAR(255) NULL,
`TblName` VARCHAR(100) NULL,
...
- 570
1
vote
1
answer
2k
views
Partitions by null values with MySQL
I have a table:
CREATE TABLE `NewTable` (
`IBLOCK_ELEMENT_ID` int(11) NOT NULL ,
`PROPERTY_1836` int(11) NULL DEFAULT NULL ,
`DESCRIPTION_1836` varchar(255) CHARACTER SET cp1251 ...
- 71
1
vote
1
answer
1k
views
Mysql: performance partitions in joining tables
I have a question with partitions and joining tables in MySQL.
I have this sample schema:
CREATE TABLE A (
`ID` BIGINT NOT NULL AUTO_INCREMENT,
`NAME` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID`),
...
- 812
0
votes
0
answers
135
views
Is reference partitioning suitable for filtering result set based on content of referenced tables?
I am using Oracle 11g. I have a messages table with about a billion records that is range partitioned on timestamp. This messages table has several reference partitioned sub tables such as names, ...
- 31
0
votes
0
answers
118
views
table partition with primary key
I have one table in mysql. here is schema for that table.
TableName : LoginDet
~~~~~~~~~~~~~~~~~~~~
loginid mediumint(8) PrimaryKey AutoIncrement
logindate timestamp Not null
userid ...
- 6,251