Hacker News with Generative AI: Database Optimization

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
252 points by justinclift 8 days ago | 54 comments
Bulk optimization of queries in Postgres (substack.com)
Database Optimization, PostgreSQL, Performance
78 points by Explain_PS 122 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 178 days ago | 2 comments
Ottertune.ai Is Shut Down (ottertune.com)
Artificial Intelligence, Startups, Database Optimization
14 points by hp77 251 days ago | 5 comments
How to get the most out of Postgres memory settings (tembo.io)
Postgres, Database Optimization, Performance Tuning
272 points by samaysharma 255 days ago | 82 comments
Making a Postgres query 1k times faster (mattermost.com)
Database Optimization, Postgres, Performance
228 points by d0mine 281 days ago | 60 comments
Making a Postgres query 1k times faster (mattermost.com)
Database Optimization, Postgres, Performance
12 points by iTokio 282 days ago | 0 comments
Optimizing ClickHouse: Tactics that worked for us (highlight.io)
Database Optimization, ClickHouse, Performance Optimization
131 points by podoman 282 days ago | 25 comments
The Bloat Busters: pg_repack vs. pg_squeeze (boringsql.com)
Database Optimization, PostgreSQL, Performance, Tools
31 points by radimm 299 days ago | 12 comments
Postgres Bloat Minimization (supabase.com)
Postgres, Database Optimization, Database Administration
24 points by oliverrice 300 days ago | 1 comments