Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

As an aside, I'm reading Greg Smith's PG 9.0 High Performance, and it's an excellent in depth study of database optimization. The first 90 pages are bottom up: storage technologies and how to tune and benchmark them, memory, cpu, file system choices, and operating system tuning parameters. Once the fundamentals are in order, it covers the internals of PG in even more interesting detail.

Trivia: A fsync call on any file on ext3 will force a sync of not just that file but the whole volume; ext4 fixes that. If you buy large SATA drives, then partition them to "short stroke" using only the outside of the disk (discarding the slower spinning inner region) you get competitive performance to SAS disks for many workloads.

One of the best low level books I've found in a long time.



Is that book full of these trivias? I would love to read more trivias like that.


You may find http://blogs.msdn.com/b/oldnewthing/ interesting (a developer at Microsoft who blogs about Windows internals).

His books is a copy of his blog with just the internals blog posts.


Why the down vote? And why is that blog so interesting again?

It's a shame the book doesn't have a Kindle edition.


It could be your use of the word 'trivia.' At least in the US, it sometimes carries a negative connotation. It might read to some like you are being sarcastic.


ohh... sorry, English is not my native language that's why I didn't knew this. I wasn't being sarcastic, I actually liked the comment.

Thanks for the explanation astine :)


Also, trivia is a mass noun. "Lots of trivia like this", not "lots of trivias like this".

"Details" or "specifics" sounds less ... trivial. "Nitty gritty details" ("let's get down to the nitty gritty") is also OK.


Would one of a body of trivia be a "trivium?"


I dont personally work with postgres but you've convinced me to buy this book.


Awesome! Ordering now.

Postgres kicks ass.




Consider applying for YC's Fall 2026 batch! Applications are open till July 27.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: