great :-) >2. Creating a partition of a partitioned table > >CREATE TABLE table_name >PARTITION OF partitioned_table_name >FOR VALUES values_spec; > >Where values_spec is: > >listvalues: [IN] (val1, ...) >
Would it make sense to allow one complementary partition to the listvalues? listvalues: [[NOT] IN] (val1, ...) I've thought a few times about moving data with some most common values to dedicated partitions and keeping the rest in a separate one... best regards, Marc Mamin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
