Re: Postcodes

[Phil Hildebrand]

Currently, outside of key type partitions, you need the field that is being partitioned to resolve to an integer value, so it depends a little on your table structure.

If you had a lookup table that contained the codes -

id 1 = AB, id 2 = NP, etc, etc

and your main table contained the codes, you could then partition on that:

create table my_info
(
postcode_id int,
other_info xxxx,
) partition by hash (postcode_id) partitions 40

(you could also use range or list partitions for that)

if postcode abbr were part of the primary key, then you could use a key partition:

create table my_info
(
id int not null,
postcode_abbr char (2),
other info xxxx,
primary key (id,postcode_abbr)
) partition by key () partitions 40