Partitions
2024-08-22
-- Create a new database CREATE DATABSE par; postgres=# select pg_database.oid, pg_database.datname from pg_database; oid | datname -------+--------------- 5 | postgres 16388 | testdump 1 | template1 4 | template0 16395 | partitiontest 24592 | testdb 24649 | par postgres=# \c par You are now connected to database "par" as user "postgres". par=# CREATE TABLE foo ( id int not null, name VARCHAR(50), amount INT NOT NULL ) PARTITION BY RANGE(amount); CREATE TABLE par=# CREATE INDEX idx_amount ON foo(amount); CREATE INDEX par=# select pg_relation_filepath('foo'); pg_relation_filepath ---------------------- (1 row) par=# \d foo Partitioned table "public.