Question : So let me preface by saying I do not have total control over my db design, so a […]
Tag: partitioning
Partitioning MySQL vs PostgreSQL
Question : For our new system we are looking for database server. We considered a lot of pros/cons for MySQL(InnoDB) […]
Partition by hash on two levels
Question : I’m trying to partition a large table by a generated ID(unfortunately it’s a mongoDB, so the first few […]
How to maintain a global index on a large table undergoing regular partition purges?
Question : Problem I’ve got giant table haystack weighing in at nearly 3 TB, partitioned by month (date) and subpartitioned […]
TSQL – merge partitions online
Question : the short version of my question is: “During the merge of two partitions is the whole partitioned table […]
What’s the best way to structure logging application data in MySQL
Question : I may be overthinking this but: I have an API; I want to log calls to the API […]
Replacing Filegroup Used in Last Partition Slice for RANGE LEFT-based Partition Scheme
Question : I have a simple date based partition function using RANGE LEFT… CREATE PARTITION FUNCTION [PF_YEAR_LEFT](date) AS RANGE LEFT […]
Is there a way to write intelligent queries against a merge table in MySQL that represents a bunch of tables partitioned by date?
Question : I have a set of MySQL tables that are partitioned by date, with a merge table representing all […]
Search is slow in a partitioned table
Question : I’m running MySQL 5.7.15 on Ubuntu server 16.04. After I’ve partitioned a table by range, select queries for […]
How to gauge performance of switching to PostgreSQL table partitioning?
Question : I have a table in a PostgreSQL database containing about 100m records that’s mostly read-only with a few […]