Questions tagged [partitioning]
Splitting a database table into multiple segments for performance or manageability.
1,096 questions
1 vote
1 answer
137 views
What does trace flag 11024 do?
Context I have been experimenting with incremental statistics a lot. I do not know of any online resource about them that I have not read. Despite all of this, I just don't understand what trace flag ...
- 1,322
1 vote
1 answer
55 views
Is there a limit to the number of values used for a list partition?
We have sensor data used for analytics that has for columns: CREATE TABLE sensor_data ( dt date NOT NULL, timeofday time without time zone NOT NULL, sensor_id TEXT NOT NULL, --...
- 615
1 vote
2 answers
191 views
What thresholds are used to trigger automatic statistics updates for incremental statistics? And how can I tell which partition updated?
The Question The idea of incremental statistics is that they make statistics updates faster. However, no documentation comments on how they interact with automatic statistics updates. This leaves me ...
- 1,322
1 vote
1 answer
101 views
Why is GROUP BY on partitioned table slower than querying child partition directly?
I have the following table partitioned by projects. CREATE TABLE IF NOT EXISTS entries ( id bigint NOT NULL, status_id bigint NOT NULL, group_id bigint NOT NULL, project_id bigint ...
- 13
0 votes
2 answers
63 views
Partitioning on a categorical (low-cardinality) column
Similar to Improving performance with a common low-cardinality field We get a large dataset and we load it by source. Let's say team_id. We currently have our data partitioned by team_id and then by ...
- 615
3 votes
2 answers
551 views
Partitioning heaps - Why?
I know, at least theoretically, that heap tables can be partitioned. As I learn more about table partitioning, I realise that the use case is very limited. Similarly, the use case for heaps in SQL ...
- 1,322
4 votes
1 answer
132 views
"The data type of a column of a partitioned table can't be changed."
The documentation claims The data type of a column of a partitioned table can't be changed. It repeats this claim elsewhere such as here. Yet I have never seen this fail. CREATE PARTITION FUNCTION ...
- 1,322
7 votes
4 answers
791 views
If all of the indexes of a table are partitioned with the same function and scheme but on different columns, is it still considered aligned?
The documentation says the following Aligned index An index that is built on the same partition scheme as its corresponding table. When a table and its indexes are in alignment, the database engine ...
- 1,322