Mr. DBA, tear down your IO!

  • October 9, 2007 · 7:30 PM
  • Arcscale

Sean Chittenden presents:

Mr. DBA, tear down your IO!


Mr and Mrs developer, for the liberalization and prosperity of
your database and application, come understand your IO! Mr
Developer, open your eyes! Mr DBA, come tear down your IO!!" Of
course I'm paraphrasing, but what does it mean to your RDBMS, OS
and infrastructure when you start mashing out transactions? How
expensive is an SQL operation in terms of IO and how much IO is
done for different datasets? Come understand a sample of IO
profiles for PostgreSQL for small (millions of rows) and large
(hundreds to billions of rows) data sets accessed via internal,
NFS, and SAN. What's the difference in IO between a SELECT,
indexed SELECTs, clustered indexes, internal storage, and a
storage array with a boatload of cache in a lab environment?

RSVP ASAP to get fed :)

Thanks very much to Arcscale for hosting.

Join or login to comment.

9 went

People in this
Meetup are also in:

Imagine having a community behind you

Get started Learn more

I decided to start Reno Motorcycle Riders Group because I wanted to be part of a group of people who enjoyed my passion... I was excited and nervous. Our group has grown by leaps and bounds. I never thought it would be this big.

Henry, started Reno Motorcycle Riders

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy