Keith Fiske

Senior Database Engineer at Crunchy Data Solutions, Inc

About

Senior Database Engineer with 7+ years of PostgreSQL experience & author of several popular third-party PostgreSQL tools (pg_partman, pg_extractor, mimeo, pg_doc_store).

Keith Fiske has presented the following presentations

    Keith Fiske Managing OS Provided PostgreSQL Packages at PGConf US 2017 [PgConf.US]

    presented by Keith Fiske


    video

    Compiling PostgreSQL from source is a relatively easy thing to do compared to most open source projects. But for production systems, using the packages the operating systems provide is generally the recommended way to go. The problem is none of them end up managing PostgreSQL quite the same, let alone anything like the original source compile. This talk will cover how some of the major Unix-bas...

    more

    Fri 31 2017 Operations
    Keith Fiske When PostgreSQL Can't, You Can at PGConf NYC 2014 [PgConf.US]

    presented by Keith Fiske

    After you've been using PostgreSQL for a while, you realize that there are some things still missing that would make using it in large, production environments easier: automated partitioning, autonomous functions, logical replication & better dump filtering. Thankfully, it's extremely easy to make add-ons to allow some of those features right now. And you don't even have to know a single line o...

    more

    Admin
    Keith Fiske PostgreSQL Partitioning at PostgresConf US 2018
    Then & Now

    presented by Keith Fiske

    Splitting data amongst tables has long been a standard practice in RDBMS systems to increase both storage and query efficiency. But until recently PostgreSQL was missing that feature natively. This talk will discuss both the old trigger based methods, the new native feature included in PostgreSQL 10 and upcoming features in 11 and beyond.

    Slides - [http://slides.keithf4.com/partitioning_then...

    more

    Postgres Internals