Hacker News Reader

Pg uses 8kb pages by default. You do really want your fs/db page size to match though except in very very specific scenarios.

Ahh, I didn't know it used 8kB page - that makes it even better, because it removes any read-modify-write cycle if you run with record size of 8k.

Why doesn't pg query the fs for the default scenario I wonder

Because it's a compile time flag, not a init or config parameter.

I agree it would be nice if the page size was more adaptive to just not have FS page size alignment issues.