HNHacker News
TopNewBestAskShowJobs

optikalfire

3 karma · joined August 27, 2025

submissionscomments
optikalfire··on LNAI – Define AI coding tool configs once, sync to Claude, Cursor, Codex, etc.
Is this substantially different than https://github.com/intellectronica/ruler? Or how would you differentiate?
optikalfire··on Bypass PostgreSQL catalog overhead with direct partition hash calculations
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?