On 2015-08-20 PM 06:27, Pavan Deolasee wrote: > On Tue, Aug 18, 2015 at 4:00 PM, Amit Langote <[email protected] >> wrote: >> >> PARTITION BY LIST ON (name) >> PARTITION BY RANGE ON (year, month) >> >> PARTITION BY LIST ON ((lower(left(name, 2))) >> PARTITION BY RANGE ON ((extract(year from d)), (extract(month from d))) >> >> > > How about HASH partitioning? Are there plans to support foreign tables as > partitions? >
I've not given HASH partitioning a lot of thought yet. About the latter, it seems it should not be too difficult to incorporate into the proposed partitioning internals. Thanks, Amit -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
