Hacker News with Generative AI: Database Optimization

The fastest Postgres inserts (hatchet.run)
At Hatchet, we spent the past half year running hundreds of benchmarks against different Postgres configurations. We set out with a simple question: at what scale does Postgres break?

Database Optimization, Postgres, Performance, Benchmarking

59 points by abelanger 7 days ago | 25 comments

Balancing the Costs of Count(*) and UX (frappe.io)
Just how bad is "select count(*)" and can we control it?

Database Optimization, User Experience, Performance

6 points by zerojames 78 days ago | 0 comments

Debunking the Myth of Join Ordering: Toward Robust SQL Analytics (arxiv.org)
Join order optimization is critical in achieving good query performance. Despite decades of research and practice, modern query optimizers could still generate inferior join plans that are orders of magnitude slower than optimal.

Database Optimization, SQL, Performance Optimization

8 points by ksec 81 days ago | 0 comments

PgAssistant: OSS tool to help devs understand and optimize PG performance (github.com/nexsol-technologies)
PgAssistant is an open-source tool designed to help developers understand and optimize their PostgreSQL database performance.

PostgreSQL, Open Source, Database Optimization, Developer Tools, Performance Optimization

253 points by justinclift 100 days ago | 54 comments

Bulk optimization of queries in Postgres (substack.com)

Database Optimization, PostgreSQL, Performance

78 points by Explain_PS 214 days ago | 7 comments

Exploiting column chunks for faster ingestion and lower memory use (rerun.io)

Database Optimization, Data Engineering, Performance Optimization

15 points by Tycho87 270 days ago | 2 comments

Ottertune.ai Is Shut Down (ottertune.com)