Implemented a crazy idea, and it successfully reduced the amount of WAL to one-third in the pgbench benchmark.
Conversation
Replying to
I am also working on something. A feature similar to MySQL's INSERT IGNORE. Close to publishing.
Replying to
This just has some tuples not inserted rather than complaining. INSERT...ON DUPLICATE KEY IGNORE.
Replying to
that is MySQL's default. You think it inserts, but it actually does not. Blackhole engine :P
2
Replying to
Or it inserts something completely different ...