Top all-time · #1307
pganalyze
Company blog · pganalyze.com/blogdataprogramming
pganalyze is the company blog at pganalyze.com, writing about data and programming. Since 2013, 54 different Hacker News readers have linked it 144 times, most often “How Postgres chooses which index to use for a query”. It is still writing: the last post was on 2026-09-17, and you can follow it by feed.
Rarely recommended · 4 of 36 sampled comments recommend it?
Why HN links it
HN readers link pganalyze's blog for practical Postgres posts on zero-downtime upgrades, query and bulk-loading performance, monitoring, JSONB, new Postgres features, and SQL parsing.
Summarised by Claude from a sample of 36 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
DBAs and developers use pganalyze to identify the root cause of performance issues, optimize queries and to get alerts about critical issues. Sign up for free!
Most-linked posts?
- How Postgres chooses which index to use for a query6 people · 8 mentions · first linked 2022-04-05
- PostgreSQL Performance Monitoring6 people · 6 mentions · first linked 2013-10-26
- An early look at Postgres 14: Performance and monitoring Improvements5 people · 6 mentions · first linked 2021-05-21
- Full Text Search in Milliseconds with Rails and PostgreSQL5 people · 5 mentions · first linked 2020-04-16
- Automatic indexing system for Postgres: How we built the pganalyze Index Engine4 people · 6 mentions · first linked 2022-06-01
- Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O4 people · 4 mentions · first linked 2025-05-07
- Understanding Postgres GIN Indexes: The Good and the Bad3 people · 3 mentions · first linked 2021-12-13
- Using Postgres Row-Level Security in Python and Django3 people · 3 mentions · first linked 2020-08-13
- Postgres 17: Streaming I/O for sequential scans and ANALYZE2 people · 3 mentions · first linked 2024-06-13
- Waiting for Postgres 19: Reduced Timing Overhead for EXPLAIN ANALYZE with RDTSC2 people · 2 mentions · first linked 2026-04-11
What Hacker News says?
I did not use a script (my environment is bare metal running ubuntu 24). I read these and then wrote my own scripts that were tailored to my environment. https://pganalyze.com/blog/5mins-postgres-zero-downtime-upgr... https://www.pgedge.com/blog/always-online-or-bust-zero-downt... https://knock.app/blog/zero-downtime-postgres-upgrades Basically - Created a new cluster on new machines - Started logically replicating…
Comment linking /blog/5mins-postgres-zero-downtime-upgrades-logical-replication
on “Go ahead, self-host Postgres”Submitted Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O as a story · 572 points
HN discussion> I would still rather work with Postgres AND have to juggle a connection pooler Is this comment relating to the overhead of idle connections, which has historically necessitated the use of a pooler in front of PG? If so, I believe this is resolved in postgres 14 https://pganalyze.com/blog/postgres-14-performance-monitorin...
Comment linking /blog/postgres-14-performance-monitoring
on “In MySQL, use “utf8mb4” instead of “utf8” (2016)”Submitted An early look at Postgres 14: Performance and monitoring Improvements as a story · 456 points
HN discussionAre these numbers the same for JSON/jsonb data? Ed: looks like it https://pganalyze.com/blog/5mins-postgres-jsonb-toast
Comment linking /blog/5mins-postgres-jsonb-toast
on “Show HN: I am building an open-source Confluence and Notion alternative”Submitted Things we learned running Postgres 13 as a story · 377 points
HN discussionpganalyze | Senior Product Engineer, Senior Solutions Engineer | REMOTE (US/Canada) | Full-time | https://pganalyze.com At pganalyze, we're redefining how developers optimize one of the world's most popular databases, PostgreSQL. Our software gives companies like Atlassian, Robinhood, and Notion the tools to solve their most complex Postgres performance challenges, ensuring their mission-critical applications run sm…
Comment linking /blog/introducing-postgres-query-tuning-workbooks
on “Ask HN: Who is hiring? (February 2025)”Submitted Postgres Incremental Backup as a story · 315 points
HN discussionwow! awesome tips. I knew COPY rocks but didn't realize it would win vs INSERT INTO SELECT FROM ! https://pganalyze.com/blog/5mins-postgres-optimizing-bulk-lo... 1/10th scale tests: psql -c 'create table temps_int2_copy as select * from temps_int2_copy where 1=0;' psql -Xq -c 'COPY (SELECT (1000*random())::int2 as city, (random()*random()*1100)::int2 temp FROM (SELECT generate_series(1,1e8::int8))) TO STDOUT WITH BI…
Comment linking /blog/5mins-postgres-optimizing-bulk-loads-copy-vs-insert
on “The One Billion Row Challenge”Submitted How Postgres chooses which index to use for a query as a story · 300 points
HN discussionpganalyze | Backend Software Engineer | REMOTE (US/CA time zones) | Full-time | Salary: $150-190k | https://pganalyze.com At pganalyze, we build observability and automation tools for optimizing the performance of Postgres databases. Our product helps customers such as Atlassian, Robinhood and DoorDash to understand complex Postgres problems and solve performance issues. We are bootstrapped, profitable, and are curr…
Comment linking /careers/backend-software-engineer
on “Ask HN: Who is hiring? (August 2022)”Submitted A practical introduction to constraint programming using CP-SAT and Python as a story · 254 points
HN discussionpganalyze ( https://pganalyze.com/ ) - Performance Monitoring for PostgreSQL databases. Its cool because: We visualise the metrics & counters that are usually hidden away in PostgreSQL internal tables. Plus we check that your database is fast and configured correctly. Also: I'm a techie with a UX hat, and data visualisation and pattern matching is fun :)
Comment linking /
on “Ask HN: What are you working on and why is it cool?”Submitted Efficient GraphQL Queries in Ruby on Rails and Postgres as a story · 176 points
HN discussionYep, there is a "link to video" link on the talk page - here is the direct link: https://www.youtube.com/watch?v=pGN_pORKtSQ We also did a more recent webinar that has some slight revisions on top of that talk, recording available in our docs: https://pganalyze.com/docs/indexing-engine/cp-model
Comment linking /docs/indexing-engine/cp-model
on “Show HN: PostgreSQL index advisor”Submitted Effectively Using Materialized Views in Ruby on Rails as a story · 158 points
HN discussionpganalyze | Senior Backend Engineer & Senior Full Stack Engineer | REMOTE (US/CA time zones) | Full-time | Salary: $140-180k | https://pganalyze.com At pganalyze, we redefine the user experience for optimizing the performance of Postgres databases. Our product helps customers such as Atlassian, Robinhood and DoorDash to understand complex Postgres problems and performance issues. Application developers use pganalyze…
Comment linking /careers/senior-backend-engineer
on “Ask HN: Who is hiring? (July 2021)”Submitted Postgres 17: Streaming I/O for sequential scans and ANALYZE as a story · 111 points
HN discussionpganalyze | Senior Product Engineer | REMOTE (US/Canada) | Full-time | $160-200k + equity | https://pganalyze.com At pganalyze, we're redefining how developers optimize one of the world's most popular databases, PostgreSQL. Our software gives companies like Atlassian, Robinhood, and Notion the tools to solve their most complex Postgres performance challenges, ensuring their mission-critical applications run smoothly…
Comment linking /careers/senior-product-engineer
on “Ask HN: Who is hiring? (March 2025)”Submitted Deconstructing the Postgres planner to find indexing opportunities as a story · 101 points
HN discussionWould "essential internal abstraction, with the introduction of read stream APIs" evolve into full storage abstraction? https://pganalyze.com/blog/5mins-postgres-17-streaming-io
Comment linking /blog/5mins-postgres-17-streaming-io
on “Databricks acquires Neon”Submitted New in Postgres 11: Monitoring JIT Performance, Auto Prewarm, Stored Procedures as a story · 73 points
HN discussionpganalyze | Deep Insights into Postgres | REMOTE (US/CA time zones) | Full-time | Salary: $140-180k | https://pganalyze.com At pganalyze, we redefine the user experience for optimizing the performance of Postgres databases. Our product helps customers such as Atlassian, Robinhood and DoorDash to understand complex Postgres problems and performance issues. Application developers use pganalyze to get deep insights int…
Comment linking /careers/senior-backend-engineer
on “Ask HN: Who is hiring? (June 2021)”Submitted Similarity in Postgres and Rails Using Trigrams as a story · 66 points
HN discussionpganalyze | Senior Backend Engineer | REMOTE (US/CA time zones) | Full-time | Salary: $140-180k | https://pganalyze.com At pganalyze, we redefine the user experience for optimizing the performance of Postgres databases. Our product helps customers such as Atlassian, Robinhood and DoorDash to understand complex Postgres problems and performance issues. We are currently preparing a significant refactoring of our backe…
Comment linking /careers/senior-backend-engineer
on “Ask HN: Who is hiring? (August 2021)”Submitted Efficient Postgres Full Text Search in Django as a story · 34 points
HN discussionI think this is partly why Amelia suggests rewriting these examples to let React handle the rendering and avoid DOM manipulation in D3. I rewrote a bunch of charting components at work a while ago, and that general approach worked really well for us. In fact, I barely ended up using d3 at all, but the bits that I did use were very handy. I found some of Amelia's other writing very useful in the process, and I blogge…
Comment linking /blog/building-svg-components-in-react
on “React and D3.js”Submitted Understanding Postgres GIN Indexes: The Good and the Bad as a story · 20 points
HN discussionpganalyze | Backend Software Engineer | REMOTE (US/CA time zones) | Full-time | Salary: $150-190k | https://pganalyze.com At pganalyze, we redefine the user experience for optimizing the performance of Postgres databases. Our product helps customers such as Atlassian, Robinhood and DoorDash to understand complex Postgres problems and performance issues. We are bootstrapped, profitable, and are currently hiring emplo…
Comment linking /careers/backend-software-engineer
on “Ask HN: Who is hiring? (July 2022)”Submitted Show HN: pganalyze Index Advisor – A better way to index your Postgres database as a story · 14 points
HN discussion
