PostgreSQL tips and tricks

Re:PostgreSQL tips and tricks by rarrrrrr on Sunday May 29, 2011 @04:59PM (#2597588)

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.

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by thepumpkin1979 on Sunday May 29, 2011 @06:15PM (#2597755)

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

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by plasma on Sunday May 29, 2011 @07:14PM (#2597886)

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.

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by thepumpkin1979 on Sunday May 29, 2011 @08:48PM (#2598028)

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

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

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by astine on Sunday May 29, 2011 @09:44PM (#2598153)

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.

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by thepumpkin1979 on Sunday May 29, 2011 @10:29PM (#2598264)

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 :)

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by wisty on Monday May 30, 2011 @01:19AM (#2598594)

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.

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by bonzoesc on Monday May 30, 2011 @11:24AM (#2599608)

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

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by chuhnk on Sunday May 29, 2011 @05:40PM (#2597674)

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

[ Parent | on HN ]

Re:PostgreSQL tips and tricks by mahmud on Sunday May 29, 2011 @09:44PM (#2598152)

Awesome! Ordering now.

Postgres kicks ass.

[ Parent | on HN ]