More on Postgres Performance

Worth reading. I had no idea you can do conditional indexes. Is that something other dbs support? (looks like mysql doesn't)

Tangent: I met Craig yesterday randomly in a coffee shop. He seemed really smart and gave me a few Postgres performance tips. I didn't know he was a big deal. I guess those are the cool twists of fate people talk about happening in the Bay Area.

I thought ratio based tuning is old-fashioned.

tl;dr<p>Use EXPLAIN ANALYZE and read the manual.