BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Pentabarf//Schedule 0.3//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALDESC;VALUE=TEXT:PostgreSQL devroom X-WR-CALNAME;VALUE=TEXT:PostgreSQL devroom X-WR-TIMEZONE;VALUE=TEXT:Europe/Brussels BEGIN:VEVENT METHOD:PUBLISH UID:8984@FOSDEM19@fosdem.org TZID:Europe-Brussels DTSTART:20190203T100000 DTEND:20190203T105000 SUMMARY:AMENDMENT Around the world with Postgres extensions DESCRIPTION:
Postgres continues to get more and more feature rich. But equally as impressive is the network of extensions that are growing around Postgres. With the rich extension APIs you can now add advanced functionality to Postgres without having to fork the codebase or wait for the main PostgreSQL release cycle.
This is a late addition to the schedule.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2019/schedule/2019/schedule/event/around_the_world_with_postgres_extensions/ LOCATION:UA2.220 (Guillissen) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Craig Kerstiens":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:8856@FOSDEM19@fosdem.org TZID:Europe-Brussels DTSTART:20190203T110000 DTEND:20190203T115000 SUMMARY:Hacking PostgreSQL DESCRIPTION:This talk will include an introduction to the backend code and an example on hacking PG and adding in a new feature.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2019/schedule/2019/schedule/event/hacking_postgresql/ LOCATION:UA2.220 (Guillissen) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Stephen Frost":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:8857@FOSDEM19@fosdem.org TZID:Europe-Brussels DTSTART:20190203T120000 DTEND:20190203T125000 SUMMARY:What's new in PostgreSQL 11 DESCRIPTION:PostgreSQL 11 is out! Do you know what your favorite feature is yet? This talk will outline some of the bigger new features in this new version of PostgreSQL, giving you a chance to pick your favorite feature -- or to change your mind if you already had one!
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2019/schedule/2019/schedule/event/whats_new_in_postgresql_11/ LOCATION:UA2.220 (Guillissen) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Magnus Hagander":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:8858@FOSDEM19@fosdem.org TZID:Europe-Brussels DTSTART:20190203T130000 DTEND:20190203T135000 SUMMARY:Deploying PostgreSQL on Kubernetes DESCRIPTION:A look at some of the ways available to deploy Postgres in a Kubernetes cloud environment, either in small scale using simple configurations, or in larger scale using tools such as Helm charts and the Crunchy PostgreSQL Operator. A short introduction to Kubernetes will be given to explain the concepts involved, followed by examples from each deployment method and observations on the key differences.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2019/schedule/2019/schedule/event/deploying_postgresql_on_kubernetes/ LOCATION:UA2.220 (Guillissen) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Jimmy Angelakos":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:8861@FOSDEM19@fosdem.org TZID:Europe-Brussels DTSTART:20190203T140000 DTEND:20190203T145000 SUMMARY:Breaking PostgreSQL at Scale DESCRIPTION:Database systems don't just slow down in a clear, linear way. They reach a certain point and start failing, often very suddenly and surprisingly.
This talk is about some of the most common scaling "discontinuities" in PostgreSQL, and how to plan for them and mitigate them. Why is SERIAL a bad primary key on high-insert-rate tables? What happens when autovacuum can't keep up? How do you know you don't have enough memory for your queries? What happens when a query that worked just fine before suddenly has a horrible plan?
Drawn from real-life examples, we'll go over these and show how to fix them… and avoid them in the first place.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2019/schedule/2019/schedule/event/breaking_postgresql_on_scale/ LOCATION:UA2.220 (Guillissen) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Christophe Pettus":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:8860@FOSDEM19@fosdem.org TZID:Europe-Brussels DTSTART:20190203T150000 DTEND:20190203T155000 SUMMARY:Data Modeling, Normalization and Denormalization DESCRIPTION:As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it’s important to understand how the schema is then going to be used as well as the trade-offs it involves.
As Fred Brooks said: “Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won’t usually need your flowcharts; they’ll be obvious.”
In this talk we're going to see practical normalisation examples and their benefits, and also review some anti-patterns and their typical PostgreSQL solutions, including Denormalization techniques thanks to advanced Data Types.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2019/schedule/2019/schedule/event/data_modeling_normalization_and_denormalization/ LOCATION:UA2.220 (Guillissen) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Dimitri Fontaine":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:8859@FOSDEM19@fosdem.org TZID:Europe-Brussels DTSTART:20190203T160000 DTEND:20190203T165000 SUMMARY:Latest evolution of Linux IO stack, explained for database people DESCRIPTION:Input-output performance problems are on every day agenda for DBAs since databases exist. In Linux - probably the most popular operating system for databases now - there is a major overhaul of the IO stack for last several years. In this talk i will review what is going on there, why the IO stack needed an urgent improvement and what all those brand new NVMe driver and blk-mq layer improvements mean for databases, and database people. As a useful takeaway, I will provide a checklist of PostgreSQL and Linux settings to maximize IO performance with the new kernels.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:PostgreSQL URL:https:/fosdem.org/2019/schedule/2019/schedule/event/latest_evolution_of_linux_io_stack_explained_for_database_people/ LOCATION:UA2.220 (Guillissen) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Ilya Kosmodemiansky":invalid:nomail END:VEVENT END:VCALENDAR