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