A Billion Taxi Rides in PostgreSQL

> PostgreSQL stores each record, regardless of attributes, in an 8K block of data (excluding TOAST fields and indices) on the disk. If you have a table with 5 columns of integers they will use 8K of disk space for each row, not 20 bytes.

This is wrong. Postgres uses 8KB blocks for heap data by default, but you can (and typically will) have multiple rows in a single page.

"PostgreSQL stores each record, regardless of attributes, in an 8K block of data (excluding TOAST fields and indices) on the disk. If you have a table with 5 columns of integers they will use 8K of disk space for each row, not 20 bytes."

Uh, no. I think you're confusing tuples and pages. You can have many (many) tuples in a single page.

How many taxi drivers using domain names ending in ".taxi": any idea?