from Hacker News

Boosting Postgres Insert Performance by 50% with Unnest

by jamesgresql on 11/16/24, 10:26 PM with 2 comments

  • by jamesgresql on 11/16/24, 10:26 PM

    Hi HN! If you're interested in PostgreSQL or database performance here's a short benchmark I did looking into the seemingly magical performance gain you can get by INSERTing unnested arrays rather than VALUES tuples in Postgres.

    Let me know if you have any questions or suggestions for next articles.