I just wrote way too much about the talks I’ll attend to at PostgreSQL Conference West. Check it out!

Let me know what you’re planning to see in the comments!

-selena

Gabrielle and I are at it again, talking about Filesystem I/O and Linux at the Linux Plumbers Conference.  Mark Wong is the evil performance genius working with us behind the scenes, and a copy of what we brought to the conference today is here.

Takeaway: Set your read ahead buffer size higher in the kernel - maybe even 8MB.

I’m learning the PostgreSQL system catalog tables right now, and was wishing that I had some catalog flashcards.  I made my wish ‘aloud’ on IRC today, and @davidfetter managed to blow my mind with this simple command-line switch for psql: -E. Now, every time I use a command, the tool tells me what the underlying SQL query is. Great for jogging the memory, and I’ll be putting off making my catalog flashcards for a few more days. Now I wonder what other revealing command-line switches I’ve overlooked!

See screenshot: