5 ms·
Is this correct? -- Parent table CREATE TABLE events ( id bigint, user_id bigint, event_type integer, payload text, created_at timestamp )
by optikalfire 1y ago
Is this correct?
-- Parent table
CREATE TABLE events (
id bigint,
user_id bigint,
event_type integer,
payload text,
created_at timestamp
) PARTITION BY HASH (user_id);
-- First level: 16 partitions by user_id
CREATE TABLE events_0 PARTITION OF events
FOR VALUES WITH (modulus 16, remainder 0)
PARTITION BY HASH (event_type);
shouldn't that be by user_id for the first 16 tables?