All Questions
Tagged with inheritance partitioning
8 questions
0
votes
1
answer
313
views
partitioning with inheritance
Reference: https://www.postgresql.org/docs/current/ddl-partitioning.html#:~:text=return%20an%20error.-,5.11.3.%C2%[…]20Using%20Inheritance,-While%20the%20built
I was trying partitioning with ...
- 362
2
votes
1
answer
1k
views
Postgres natively partitioned tables - adding extra child columns
With Postgres native partitioning, can you add extra columns to a partition of the base table? Like:
CREATE TABLE item (
tenant_id bigint NOT NULL,
item_id bigint NOT NULL,
kind text NOT ...
- 179
0
votes
1
answer
522
views
Table Partitioning Using Inheritance and Triggers
I am trying to do table partitioning in PostgreSQL using inheritance and triggers but the problem that have occured to me is that the data does not move from the parent table to the children tables I ...
- 3
0
votes
1
answer
1k
views
PostgreSQL Trigger to override insert on table with inheritance
We have a table documents that is partitioned by time into child tables like documents_2019_01, documents_2019_02. We do this using a BEFORE trigger on the parent documents table to insert into the ...
- 115
1
vote
0
answers
1k
views
PostgreSQL doesn't use index on inherited tables
I have two tables in PostgreSQL 9.4.5 deployed on Amazon RDS:
an append only, weekly partitioned, All Positions table. These store all position readings from about 100,000 sensors. There are about 50 ...
- 111
6
votes
1
answer
3k
views
Index is not used with table inheritance
I have a PostgreSQL 9.0.12 database with a master table and 2 child tables. My tables:
CREATE TABLE test2 (
id serial PRIMARY KEY,
coll character varying(15),
ts timestamp without time ...
- 285
7
votes
1
answer
5k
views
Performance issues with inherited tables and indices
I have a PostgreSQL database with a master table and 2 child tables.
My master table:
CREATE TABLE test (
id serial PRIMARY KEY,
date timestamp without time zone
);
CREATE INDEX ON test(...
- 285
0
votes
1
answer
347
views
Partitioning table with billion row
I have a big table referenced by other tables and need to split the table
on several parts.
I create table by CREATE TABLE product_part0 () INHERITS (product);
Move some rows to product_part0 by ...
- 121