HNHacker News
TopNewBestAskShowJobs

lfittl

1,954 karma · joined October 30, 2007

Lukas Fittl

Founder of pganalyze - Postgres performance at any scale.

Feel free to drop me an email: lukas@fittl.com

[ my public key: https://keybase.io/lukasfittl; my proof: https://keybase.io/lukasfittl/sigs/rqDeEWdp4ktJubli4QY0dNaUJ6K-pdpDTHCFOi9v7WU ]

submissionscomments

PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit

ubicloud.com·3 pts·lfittl·
0

Waiting for Postgres 19: Reduced Timing Overhead for EXPLAIN ANALYZE with RDTSC

pganalyze.com·2 pts·lfittl·
0

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

pganalyze.com·572 pts·lfittl·
154

Constraint Programming in Action: Optimizing Postgres Index Selection

pganalyze.com·2 pts·lfittl·
0

A practical introduction to constraint programming using CP-SAT and Python

pganalyze.com·254 pts·lfittl·
39

Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io

pganalyze.com·168 pts·lfittl·
29

Soft deletion probably isn't worth it

brandur.org·654 pts·lfittl·
494

PostgreSQL 15 Beta 1 Released

postgresql.org·13 pts·lfittl·
0

Fighting PostgreSQL write amplification with HOT updates

adyen.com·3 pts·lfittl·
0

SQL: One of the Most Valuable Skills

craigkerstiens.com·12 pts·lfittl·
9

How Postgres Chooses Which Index to Use for a Query

pganalyze.com·5 pts·lfittl·
0

A detailed guide to colors in data vis style guides

blog.datawrapper.de·1 pts·lfittl·
0

What Makes Postgres Great

twitter.com·9 pts·lfittl·
0

Understanding Postgres GIN Indexes: The Good and the Bad

pganalyze.com·20 pts·lfittl·
1

Show HN: pganalyze Index Advisor – A better way to index your Postgres database

pganalyze.com·14 pts·lfittl·
1

An early look at Postgres 14: Performance and Monitoring Improvements

pganalyze.com·7 pts·lfittl·
0

Efficient Postgres Full Text Search in Django

pganalyze.com·34 pts·lfittl·
2

Building a recommendation engine inside Postgres with Python and Pandas

info.crunchydata.com·3 pts·lfittl·
0

Using Postgres and pgRouting to explore the smooth waves of yacht rock (2020)

info.crunchydata.com·5 pts·lfittl·
0

Things we learned running Postgres 13

pganalyze.com·377 pts·lfittl·
49

Control Runaway Postgres Queries with Statement Timeout

info.crunchydata.com·3 pts·lfittl·
0

Read/Write Splitting with Azure Postgres

techcommunity.microsoft.com·5 pts·lfittl·
0

The Engineering Manager/Product Manager Marriage

craigkerstiens.com·3 pts·lfittl·
0

Postgres tips for the average and power user

citusdata.com·138 pts·lfittl·
9

The most useful Postgres extension: pg_stat_statements

citusdata.com·4 pts·lfittl·
0

Materialized views vs. Rollup tables in Postgres

citusdata.com·40 pts·lfittl·
8

Designing Your SaaS Database for Scale with Postgres

citusdata.com·7 pts·lfittl·
1

Guidance on Performing Retrospectives

craigkerstiens.com·37 pts·lfittl·
4

How Citus Enables Scalable PostgreSQL on AWS [video]

youtube.com·5 pts·lfittl·
0

Why we've doubled down on AWS and the cloud

blog.codeship.io·53 pts·lfittl·
40
Page 1 of 2Next →