Questions tagged [range-partitions]
11 questions
1
vote
3 answers
How to get range partition details from system catalogs
I am looking for a solution that lists all the range partition information. Tried the below query.
SELECT c.relname as partition_list,p.relname as parent_tbl FROM pg_inherits i JOIN pg_class p ON i.inhparent = p.oid
JOIN pg_class c ON i.inhrelid =…
dp1212
- 69
- 2
- 8
1
vote
1 answer
Partitions by Range with two columns in Kudu table
I'm trying to create a kudu table partitioned by hash and by range with 2 variables (year, month), My problem is that I want to make biannual range partitions, without add more columns in the table.
In the…
Sil
- 11
- 3
1
vote
0 answers
Attach Partition takes more time even after adding check constraint
So basically we have a very large table in Postgres 11 DB which has hundreds of millions of data since the table was added. Now we are trying to convert it into a range based partition table based on created_at column (timestamp - not nullable).
As…
Rohit Singh
- 2,143
- 3
- 13
- 16
0
votes
1 answer
POSTGRES - Range Partitioning
I have table which is already designed to partition based on month range.
I am writing code in java to check all existing partitions and would create a new one when it doesnt exist.
If I create a new range partition for the upcoming month, will…
Prashant
- 3
- 1
0
votes
0 answers
Partition tables getting locked due to a process which supports XA protocol
Upon starting our system server, the tables which are having partitions upon them(Range paritioning in postgres) are getting locked(in a way that SELECT query is still fetching output from them) but there are some ALTER statements which are getting…
Rohit K
- 1
- 1
0
votes
1 answer
Should I create a partition on a dedicated sql pool table only when there are more than 1 million rows per distribution?
I'm trying to create a new table in a dedicated SQL pool which will have approx. 43800 records each month. My questions are -
Should I create month-wise partitions?
When should I create a partition, my understanding as per the Microsoft…
Vivek KB
- 49
- 6
0
votes
0 answers
Postgresql - Optimize ordering of columns in table range partitioning with multiple columns range
I am testing with creating a data warehouse for a relatively big dataset. Based on ~10% sample of the data I decided to partition some tables that are expected to exceed memory which currently 16GB
Based on the recommendation in postgreSQL docs:…
smg77
- 5
- 1
- 2
0
votes
1 answer
Invalid datatype for range function
I am trying to use range partition on a table for a column of type number. However, Oracle 12c throws an error saying it is an invalid data-type. I don't understand why/what is invalid in the command.
create table partition_tester (
some_column…
Shravan J Kumar
- 158
- 1
- 1
- 10
0
votes
1 answer
SQL Server partitions: finding min / max value from metadata (i.e. sys.partition_range_values) rather than the table itself
I've an unique requirement for finding min / max value from a partition's range values. The idea is to gain on response time by querying metadata rather than the table itself.
for e.g. I've a table partitioned on business date. when I do a min / max…
user14227141
- 1
- 1
0
votes
1 answer
IMPALA - How to get range partition size
For Parquet table I use SHOW FILES IN db_name.parquet_table_name to get all my partitions names, size and path for my Parquet table.
For Range partitions I use SHOW RANGE PARTITIONS db_name.kudu_table_name This give me only the partitons ranges but…
mongotop
- 7,114
- 14
- 51
- 76
-1
votes
1 answer
How to create multiple column partitions for postgresql db, one for time range and one for specific sensor ID?
I have one application to store and query the time series data from multiple sensors. The sensor readings of multiple months needed to be stored. And we also need add more and more sensors in the future. So I need consider the scalability in two…
yyuankm
- 295
- 4
- 22