8 ms·
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:
by rarrrrrr 15y ago
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.
- chuhnk 15y agoI dont personally work with postgres but you've convinced me to buy this book.
- thepumpkin1979 15y agoIs that book full of these trivias? I would love to read more trivias like that.
- plasma 15y agoYou may find http://blogs.msdn.com/b/oldnewthing/ 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.
- thepumpkin1979 15y agoWhy the down vote? And why is that blog so interesting again? It's a shame the book doesn't have a Kindle edition.
- astine 15y agoIt 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.
- thepumpkin1979 15y agoohh... 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 :)
- deleted 15y ago[deleted]
- mahmud 15y agoAwesome! Ordering now. Postgres kicks ass.