PostgreSQL 9.0 High Performance
by Gregory Smith · first published 2010
86% recommend14% neutral
Why HN recommends it
Practical guide to tuning PostgreSQL performance, covering instance settings and getting more from server hardware. It is a go-to for working DBAs and developers running production systems.
Summarised by Claude from recommending comments
PostgreSQL database servers have a common set of problems they encounter as their usage gets heavier and requirements more demanding. You could spend years discovering solutions to them all, step by step as you encounter them. Or you can just look in here. All successful database applications are destined to eventually run into issues scaling up their performance. Peek into the future of your PostgreSQL database's problems today. Know the warning signs to look for, and how to avoid the most common issues before they even happen. Surprisingly, most PostgreSQL database applications evolve in the
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
They ink to PostgreSQL 9.0 High Performance (http://www.amazon.com/gp/product/184951030X/), which I agree is a great book if you're a sysadmin supporting PostgreSQL.
on “A Curated Guide to PostgreSQL” ↗…example look at Tom Lane's "http://www.pgcon.org/2011/schedule/events/350.en.html [4] Speaking of books a few of the best I'm aware of are: - PostgreSQL 9 Admin Cookbook (Simon Riggs, Hannu Krosing) - PostgreSQL 9.0 High Performance (Gregory Smith) - Instant PostgreSQL Backup and Restore How-to (Shaun M. Thomas) all them from Packt Publishing [1] http://www.postgresql.org/docs/devel/static/ [2] http://wiki.postgresql.org/wiki/Main_Page…
on “PostgreSQL 9.3 Beta 1 Released” ↗PostgreSQL 9.0 High Performance, Gregory Smith Postgresql 9 Administration Cookbook, Simon Riggs, Hannu Krosing
on “How I work with Postgres – psql, My PostgreSQL Admin” ↗…the post are pretty arbitrary and useless as their comments in postgresql.conf used to be. I am using PostgreSQL in production since 7.4 and the best source of performance tuning tips for me has been PostgreSQL 9.0 High Performance by Gregory Smith. These days PostgreSQL wiki is pretty good as well.
on “Vertically Scaling PostgreSQL” ↗I also like PostgreSQL 9.0 High Performance by Gregory Smith.
on “PostgreSQL Exercises” ↗Greg Smith's PostgreSQL 9.0 High Performance [1] Cary Milsap's Optimizing Oracle Performance [2], and - a pale third, Davidson and Ford's Performance Tuning with SQL Server Dynamic Management Views [3] The first 2 are bottom-up, structured approaches…
on “Postgres 9.2 will feature linear read scalability up to 64 cores” ↗I've had some great experiences, e.g. Gregory Smith's PostgreSQL 9.0 High Performance. When considering purchasing a book on a niche topic like Magneto or PostgreSQL, I think it's worth waiting for prominent community members to get review copies and write about their impression, e.g.…
on “Download any ebook free from Packt Publishing (through the end of the month)” ↗…https://www.amazon.com/Designing-Data-Intensive-Applications... This book gets mentioned a bunch around here and for a good reason. There aren't too many concrete resources on making your systems "webscale" and this one is really good. # PostgreSQL 9.0 High Performance https://www.amazon.com/PostgreSQL-High-Performance-Gregory-S... Discusses all the different settings and tweaks you can do in Postgres. It's crazy how much of a perf gain you can get just by twiddling…
on “Ask HN: What is the best online resource to learn advanced SQL?” ↗…practice advice for postgres users: 1) If you are using an older version of Postgres, upgrade to Postres 9. It has a lot of huge improvements over previous versions. 2) Purchase & read Greg Smith's PostgreSQL 9.0 High Performance (as mentioned previously by another poster). This book is phenomenal.
on “PostgreSQL tips and tricks” ↗PostgreSQL 9.0 High Performance is a Packt book with excellent content, but it has multiple typos and grammar errors on every page. I'm sad to see such an outstanding book marred by bad editing.
on “Why I left Heroku, and notes on my new AWS setup” ↗Too much negativity here. Some of their books are good. I have both PostgreSQL 9 Admin Cookbook and PostgreSQL 9.0 High Performance and they are pretty good books.
on “All Packt ebooks are $5” ↗The PostgreSQL 9.0 High Performance book has been great for us, goes in depth into most interest variables that you can tweak on your instance to make sure you're making the most out of your machine's resources: http://www.packtpub.com/postgresql-90-high-performance/book…
…Server 2008 T-SQL Querying: T-SQL Querying https://books.google.com/books?id=FZlCAwAAQBAJ&printsec=fron... Good resource for designing high performing queries and investigating performance problems. PostgreSQL 9.0: High Performance https://books.google.com/books?id=OWOAu0GcsqoC&printsec=fron... Greg lays out a great foundation for doing performance analysis that is largely applicable to any rdbms platform. Optimizing Oracle Performance…
on “Techniques for Microsoft SQL database design and optimization” ↗…requirements are no longer being met, it's easy to blame the tool (the RDBMS), but I think a much safer assumption is to blame the developer and hit the books. The PostgreSQL 9.0 Administration Cookbook and PostgreSQL 9.0 High Performance books are surprisingly good reads. It doesn't take all that much personal effort really. Less certainly than switching tool-chains. This is one of those comments you write, goes off-track, and then decide…
on “NoSQL is a bullshit marketing term” ↗Seconding this. Packt Publishing is really hit or miss, but PostgreSQL 9.0 High Performance is a hit.