Mr. DBA, tear down your IO!

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

Sean Chittenden presents:

Mr. DBA, tear down your IO!

Synopsis:

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:

illustration

Sometimes the best Meetup Group is the one you start

Start a Meetup Group

Log in

Not registered with us yet?

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