News for hackers. Stuff that matters.
Re:One word in PostgreSQL unlocked a 9x performance improvement by ivoras on Sunday June 14, 2020 @03:20PM (#23520513)
There's one HUGE upside for doing it the current way: autogenerated columns.

E.g.

    CREATE TABLE t (id SERIAL PRIMARY KEY, x INTEGER UNIQUE);

    INSERT INTO t (x) VALUES (42), (43) ON CONFLICT DO NOTHING RETURNING *;
This does EXACTLY the most useful thing if one of '42' or '43' conflicts.

There are no comments on this comment yet.