Because everything’s better with bacon

Wednesday, October 1, 2008

What to expect, when you’re expecting to go to PostgreSQL Conference West 2008

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

posted by selenamarie at 5:00 pm  

Friday, September 19, 2008

Linux Plumbers Conference: Filesystem I/O under a database workload

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.

posted by selenamarie at 7:30 am  

Monday, September 15, 2008

Command-line trick to help your memory

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:

posted by admin at 11:08 pm  

Powered by WordPress