I have been reading about scalable architectures recently. In that context, two words that keep on showing up with regards to databases are sharding and partitioning. I looked up descriptions but s...

Our Azure Cosmos DB collection has gotten large enough to require a partition key. In doing some reading about this, I get the impression that the best partition key is one that provides for even d...

I have access to a database and I need to know the Partition Scheme definitions in the database. i.e. I need to know the partition scheme name, which Partition function is it using, what file group...

Having error while running this query Query on Athena SELECT * FROM "db"."thermostat" where id='95686' and "date" = '2022/03/07' AND hour =13 Projection Partition D...

I made partition my 300MB table and trying to make select query from p0 partition with this command SELECT * FROM employees PARTITION (p0); But I am getting following error ERROR 1064 (42000): ...

Actually I am new to PostgreSQL. I want to alter existing partition to increase range value. For example I have below partition PQR_271 FOR VALUES FROM ('260000000') TO ('270000000') Here I want to...

I am looking for a way to approximate the number of rows in a partitioned table. I want to avoid using count(*) because of the size of the data. I tried using this: SELECT reltuples FROM pg_class ...

Suppose I've the following data in my container: { "id": "1DBF704E-1623-4844-DC86-EFA729A5C048", "firstName": "Wylie", "lastName": "Ramsey&...

I have a table with a trigger that updates a "modified" timestamp whenever the record changes. I did it with a BEFORE trigger: CREATE OR REPLACE FUNCTION update_modified() RETURNS trigger AS $$ B...

Working in an Oracle 19c database on Linux x86/64 trying to convert non-partitioned table to partitioned table. Since Oracle12, alter table modify partition has been available to convert non-partit...

TL;DR: we have long-running imports which seem to hold locks on the parent partitioned table even though nothing is directly referencing the parent table. Background In our system, we have inventor...

Is it even possible to add a partition to an existing table in Athena that currently is without partitions? If so, please also write syntax for doing so in the answer. For example: ALTER TABLE tabl...

I would like to do a daily partitions. I know with oracle is something like this. CREATE TABLE "PUBLIC"."TEST" ( "ID" NUMBER(38,0) NOT NULL ENABLE, "SOME_FIELD" VARCHAR2(20 BYTE) NOT NULL ENAB...

I'm trying to insert information in a partition table, but I don't know what I'm doing wrong! Show me this error: ORA-14400: inserted partition key does not map to any partition" The table dba_tab...

I have a very large 500 million rows table with the following columns: id - Bigint - Autoincrementing primary index. date - Datetime - Approximately 1.5 million rows per date, data older 1 year...

CREATE TABLE countrymeasurements ( countrycode int NOT NULL, countryname character varying(30) NOT NULL, languagename character varying (30) NOT NULL, daysofoperation character varying(30) NOT ...

Whats the best way to add another partition to an already partitioned table? The original CREATE TABLE statement looks like: CREATE TABLE `command_log` ( `id` bigint(20) NOT NULL, `insert_time...

I have an existing table in a postgres-DB. For the sake of demonstration, this is how it looks like: create table myTable( forDate date not null, key2 int not null, value int not null, primary...

When I read about sharding, looks like authors don't take into account other tables the sharded table has to be joined to (even though they describe a shard as a "subset of an original database"). ...

I have a table with many duplicated rows - but I only want to deduplicate rows one partition at a time. How can I do this? As an example, you can start with a table partitioned by date and filled...

I am trying to ALTER a table to use partitions LIST in postgres 11. I have been trying for hours but i keep getting errors. I have a huge table, clients, with ( client_id, customer_id, value). I...

We are using a public dataset to benchmark BigQuery. We took the same table and partitioned it by day, but it's not clear we are getting many benefits. What's a good balance? SELECT sum(score) FR...

I have a BigQuery table - day partitioned, and clustered. However, it still uses a lot of data when I run queries over it. How is this possible?

I want to use a partitioning method for dividing my table into two dimension: The first dimension is a list of keys. The list can grow over time and i do not want to need a DBA for adding partiti...

I have 32 years of data that I want to put into a partitioned table. However BigQuery says that I'm going over the limit (4000 partitions). For a query like: CREATE TABLE `deleting.day_partition`...