Lotus Reader - The Hackernews Client

Lotus Reader

If you click (or tap) on the name of a parent in a discussion, you will be directed to the comment that the parent wrote.

petergeoghegan

4 years ago

In reply toWhy Uber Engineering Switched from Postgres to MySQL (2016)by syspec

I committed a patch that added a mechanism I called "bottom-up index deletion" recently:

https://www.postgresql.org/docs/devel/btree-implementation.h...

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit...

Bottom-up deletion is specifically designed to ameliorate what the blog post refers to as "write amplification". Testing has shown that it's very effective with many workloads.

Tostino4 years ago

Just wanted to say how impressed I was with this solution and the results it achieved when I was following the development on -hackers.

petergeogheganTostino4 years ago

Thanks

syspecTostino4 years ago

What is -hackers?

petergeoghegansyspec4 years ago

The Postgres community mailing list for development work -- pgsql-hackers.