Keith Fiske
Senior Database Engineer at Crunchy Data Solutions, Inc
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).
Upcoming presentations
No upcoming presentations...
Past presentations
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...
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...
PostgreSQL Partitioning
Then & Now
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...