lfittl's submissions | Hacker News

1.		Waiting for Postgres 19: Reduced Timing Overhead for EXPLAIN ANALYZE with RDTSC (pganalyze.com)
		2 points by lfittl 9 days ago \| past \| discuss
2.		Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O (pganalyze.com)
		572 points by lfittl 11 months ago \| past \| 154 comments
3.		Constraint Programming in Action: Optimizing Postgres Index Selection (pganalyze.com)
		2 points by lfittl on Aug 2, 2024 \| past
4.		A practical introduction to constraint programming using CP-SAT and Python (pganalyze.com)
		254 points by lfittl on July 3, 2024 \| past \| 39 comments
5.		Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io (pganalyze.com)
		168 points by lfittl on Feb 17, 2023 \| past \| 29 comments
6.		Soft deletion probably isn't worth it (brandur.org)
		654 points by lfittl on July 19, 2022 \| past \| 494 comments
7.		PostgreSQL 15 Beta 1 Released (postgresql.org)
		13 points by lfittl on May 19, 2022 \| past
8.		Fighting PostgreSQL write amplification with HOT updates (adyen.com)
		3 points by lfittl on May 11, 2022 \| past
9.		SQL: One of the Most Valuable Skills (craigkerstiens.com)
		12 points by lfittl on April 26, 2022 \| past \| 9 comments
10.		How Postgres Chooses Which Index to Use for a Query (pganalyze.com)
		5 points by lfittl on April 12, 2022 \| past
11.		A detailed guide to colors in data vis style guides (datawrapper.de)
		1 point by lfittl on March 30, 2022 \| past
12.		What Makes Postgres Great (twitter.com/craigkerstiens)
		9 points by lfittl on March 1, 2022 \| past
13.		Understanding Postgres GIN Indexes: The Good and the Bad (pganalyze.com)
		20 points by lfittl on Dec 13, 2021 \| past \| 1 comment
14.		Show HN: pganalyze Index Advisor – A better way to index your Postgres database (pganalyze.com)
		14 points by lfittl on Sept 23, 2021 \| past \| 1 comment
15.		An early look at Postgres 14: Performance and Monitoring Improvements (pganalyze.com)
		7 points by lfittl on May 21, 2021 \| past
16.		Efficient Postgres Full Text Search in Django (pganalyze.com)
		34 points by lfittl on Feb 25, 2021 \| past \| 2 comments
17.		Building a recommendation engine inside Postgres with Python and Pandas (crunchydata.com)
		3 points by lfittl on Oct 1, 2020 \| past
18.		Using Postgres and pgRouting to explore the smooth waves of yacht rock (2020) (crunchydata.com)
		5 points by lfittl on Sept 24, 2020 \| past
19.		Things we learned running Postgres 13 (pganalyze.com)
		377 points by lfittl on Sept 21, 2020 \| past \| 49 comments
20.		Control Runaway Postgres Queries with Statement Timeout (crunchydata.com)
		3 points by lfittl on Aug 29, 2020 \| past
21.		Read/Write Splitting with Azure Postgres (techcommunity.microsoft.com)
		5 points by lfittl on Dec 16, 2019 \| past
22.		The Engineering Manager/Product Manager Marriage (craigkerstiens.com)
		3 points by lfittl on July 31, 2019 \| past
23.		Postgres tips for the average and power user (citusdata.com)
		138 points by lfittl on July 29, 2019 \| past \| 9 comments
24.		The most useful Postgres extension: pg_stat_statements (citusdata.com)
		4 points by lfittl on Feb 8, 2019 \| past
25.		Materialized views vs. Rollup tables in Postgres (citusdata.com)
		40 points by lfittl on Nov 6, 2018 \| past \| 8 comments
26.		Designing Your SaaS Database for Scale with Postgres (citusdata.com)
		7 points by lfittl on Feb 13, 2018 \| past \| 1 comment
27.		Guidance on Performing Retrospectives (craigkerstiens.com)
		37 points by lfittl on Dec 26, 2017 \| past \| 4 comments
28.		How Citus Enables Scalable PostgreSQL on AWS [video] (youtube.com)
		5 points by lfittl on Dec 21, 2016 \| past
29.		Why we've doubled down on AWS and the cloud (codeship.io)
		53 points by lfittl on Sept 24, 2013 \| past \| 40 comments
30.		Product management hacks for when you’re strapped for resources (medium.com/building-with-the-builders)
		6 points by lfittl on July 2, 2013 \| past \| 1 comment
		More

HN For You