Philly PostgreSQL User Group

Understanding PostgreSQL IO

Like any database, PostgreSQL is very dependent on the system's IO. In many situation's a poor performing database is directly related to how PostgreSQL is reading or writing to the disk. A key factor in improving performance is understanding how PostgreSQL is interacting with the disk. Come join the discussion led by Jan Wieck about what in PostgreSQL causes what kind of IO and the resulting considerations of filesystem layout and tuning options.

Jan Wieck is a former PostgreSQL CORE member and long standing key developer of the PostgreSQL database project. He is the author of several features including PL/pgSQL, NUMERIC, TOAST and the background writer. Jan is working full time on PostgreSQL and the Slony-I replication system on behalf of Afilias.

Join or login to comment.

  • lex r
    lex r

    Eyeopening. I always though more buffers was always better.
    Started to get lost a bit with turning off asynchronous commits.

    October 13

25 attended

People in this
Meetup are also in:

106,862,428 RSVPs!
hide

Log in

Not registered with us yet?

Forgot your password?

or

Sign up

Meetup members, Log in

or
By clicking the "Sign up using Facebook" or "Sign up" buttons above, you agree to Meetup's Terms of Service