Andres Freund

PostgreSQL Hacker at CitusData

About

Andres is a PostgreSQL committer and developer, focusing on replication, scalability and robustness. Before Citus Data he worked as a PostgreSQL Developer and Consultant at 2ndQuadrant and as a freelancing consultant in the areas of databases and software engineering. He has been developing Postgres and other Open Source projects since 2005. In his free time he enjoys climbing, diving and reading paper books.

Andres Freund has presented the following presentations

    Andres Freund Speeding up Query Execution at PGConf US 2017 [PgConf.US]

    presented by Andres Freund


    video

    PostgreSQL query execution performance is pretty good for many typical OLTP (i.e. individually short and concurrently issued) type queries, but performance for queries processing large amounts of data (e.g. OLAP queries) sometimes is a bit lacking. Some of those concerns can e addressed by increasing parallelism, and work on that is in progress, with the first queries being parallelized in Post...

    more

    Internals
    Andres Freund IO in Postgres - Architecture, Tuning, Problems at PGConf US 2016 [PgConf.US]

    presented by Andres Freund

    To get the most out of PostgreSQL when used in an I/O intensive environment will often require some tuning. Aside from a few basic guidelines, tuning requires some understanding of how Postgres does I/O, how it caches data and so forth. Among others we'll go through the architecture of the buffer cache ('shared_buffers'), how checkpointing (checkpoint_segments) influences performance, what the ...

    more

    Internals