Why not have a table type that writes no WAL and is truncated whenever postgres starts? Such a table could then be put in a ramdisk tablespace and there would be no transaction atomicity repercussions. Is there something I'm missing?
Is this not in the TODO (if not already scheduled for next version ?) Check ALTER TABLE SET PERSISTENCE ...