List partition

Partition by a list of values.

List partition

List partition splits by specific values. Ideal for region or category.

CREATE TABLE customers (...) PARTITION BY LIST (city);
CREATE TABLE customers_istanbul PARTITION OF customers
  FOR VALUES IN ('İstanbul');

Istanbul customers in a separate partition.

The table customers is created.

List partition — details

List partition defines a value list with FOR VALUES IN.

For example, FOR VALUES IN ('İstanbul', 'Ankara') puts rows of these two cities in one partition; a DEFAULT partition can catch values not in any list.

Exercise List partition

Create the customers_istanbul partition with FOR VALUES IN ('İstanbul').

Show example solution

CREATE TABLE customers_istanbul PARTITION OF customers
  FOR VALUES IN ('İstanbul');

Test yourself

List partition: match the terms

LIST

value list
FOR VALUES IN

values
city

region
category

class

Add LIST

PARTITION BY ____ (city)

Show answer

PARTITION BY LIST (city)

What does list partition split by?
- Specific values
- A hash
- A range
- A date
Show answer

Specific values — List partition splits by specific values.

Next lesson: Hash partition

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies