hakibenita.com on Hacker News

8 stories on the front page, newest first. Scroll down to watch the site change over time.

Screenshot of hakibenita.com: Unconventional PostgreSQL Optimizations

Unconventional PostgreSQL Optimizations (hakibenita.com)

398 points by haki 9 months ago | 63 comments

Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.

postgresql query-optimization database-performance sql

Screenshot of hakibenita.com: How to Get Foreign Keys Horribly Wrong

How to Get Foreign Keys Horribly Wrong (hakibenita.com)

50 points by Bogdanp 1 year ago | 24 comments

Screenshot of hakibenita.com: How to Get or Create in PostgreSQL

How to Get or Create in PostgreSQL (hakibenita.com)

74 points by todsacerdoti 2 years ago | 14 comments

Screenshot of hakibenita.com: The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (2020)

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (2020)(hakibenita.com)

77 points by skadamat 3 years ago | 27 comments

Screenshot of hakibenita.com: Lesser Known Postgres Features (2021)

Lesser Known Postgres Features (2021)(hakibenita.com)

78 points by skadamat 3 years ago | 12 comments

Screenshot of hakibenita.com: An unexpected find that freed 20GB of unused index space (2021)

An unexpected find that freed 20GB of unused index space (2021)(hakibenita.com)

267 points by skadamat 3 years ago | 56 comments

Screenshot of hakibenita.com: Outliers can trick the optimizer into the wrong plan

Outliers can trick the optimizer into the wrong plan (hakibenita.com)

33 points by nalgeon 3 years ago | 4 comments

Screenshot of hakibenita.com: The many faces of DISTINCT in Postgres (2017)

The many faces of DISTINCT in Postgres (2017)(hakibenita.com)

160 points by rsecora 3 years ago | 58 comments