PGX, Inc.

The OSCON 2019 awards honored PostgreSQL with the Lifetime Achievement Award. Our own Christophe Pettus, along with Bruce Momjian and Mark Wong accepted the award on the project's behalf.

PostgreSQL can handle a database at any size but how the database is used will change depending on how large the database is. This talk goes over the different levels of database sizes and tips and tricks on how to use them.

PostgreSQL version 10 has added logical replication, and now the field of replication options in PostgreSQL has gotten wide: Streaming replication, warm standby, logical replication… This talk will discuss what the options are, their limitations and pitfalls, and what the best use-case for each one is. Christophe Pettus shows what it takes to set each one up, monitor it, and get it working again on failures.

... or, Data Modeling in the Age of Social Networks.

We're now building systems that collect data on every aspect of someone's life: Not just their name and address, but their gender(s), family, relationships, movements, preferences...

And all of the assumptions we make about people in these models are probably wrong. What's a "name"? What's a "family"? What's a "relationship"? How do we model the vast complex reality of human life in a data system... and do so ethically, legally, and with an eye to the realities of how people live?

We'll talk about the range of issues this brings up, from basic low-level schema issues through user experience concerns, as well as touching on ethical, legal, and regulatory compliance issues in collecting this sort of data.

Every instance of database corruption is unique. In this talk, we'll talk about some specific, real-world examples of PostgreSQL database corruption, and how they were repaired. We'll step through each one with how we detected it, how we isolated the issue, and what we did to patch it... and what did and didn't work.

Every instance of database corruption is unique. In this talk, we'll talk about some specific, real-world examples of PostgreSQL database corruption, and how they were repaired. We'll step through each one with how we detected it, how we isolated the issue, and what we did to patch it... and what did and didn't work.

There are many ways database servers can be vulnerable to attacks. This talk delves into many of the ways a PostgeSQL database server can be secured.

Django 1.8/1.9 adds a whole bunch of cool new features that are specifically designed for PostgreSQL. We'll take a quick tour through them, and show when and how you can use them in real-world applications. We'll also talk about how to get the best performance out of PostgreSQL when using the Django ORM.

Django 1.8/1.9 adds a whole bunch of cool new features that are specifically designed for PostgreSQL. We'll take a quick tour through them, and show when and how you can use them in real-world applications. We'll also talk about how to get the best performance out of PostgreSQL when using the Django ORM.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

If you handle credit card numbers, your application and database are probably not PCI (Payment Card Information) compliant. Yes, this means you. We'll talk about what is required and forbidden when dealing with payment card information at the database layer. We'll talk about policies and procedures, security best practices, encryption, and things you must never, ever do.

Among the topics are: A survey of the new Django 1.8 PostgreSQL features. Using migrations with PostgreSQL in interesting ways. Real-life applications of the new field types. Basic model design for good performance on PostgreSQL.

Django 1.8 adds a whole bunch of cool new features that are specifically designed for PostgreSQL. We'll take a quick tour through them, and show when and how you can use them in real-world applications. We'll also talk about how to get the best performance out of PostgreSQL when using the Django ORM.

PostgreSQL has become the default database for most green-field development projects, and is the data storage architecture behind many major Python-based success stories, such as Instagram. Despite a reputation as being complex and fiddly, Postgres is easy to install, administer, maintain, and use... with just a little bit of orientation. This is that orientation.

PyCon Australia is the national conference for users of the Python Programming Language. In August 2014, we're heading to Brisbane to bring together students, enthusiasts, and professionals with a love of Python from around Australia, and all around the World.

Recovering from PostgreSQL Crises and Disasters

Tips and tricks on how ensure django runs fast.

"PostgreSQL has become the default database for most green-field development projects, and is the data storage architecture behind many major Python-based success stories, such as Instagram. Despite a reputation as being complex and fiddly, Postgres is easy to install, administer, maintain, and use... with just a little bit of orientation.This is that orientation."

With the new JSON features in 9.2, PostgreSQL has more options for handling unstructured data than ever before, while retaining the full typing system, relational integrity, and data safety features of a full RDBMS. We'll go over the various schema-less data storage options in PostgreSQL, with a focus on the new JSON features. We'll talk about indexing, using JSON and other unstructured types in functions within PostgreSQL, and performance considerations.

With the new JSON features in 9.2, PostgreSQL has more options for handling unstructured data than ever before, while retaining the full typing system, relational integrity, and data safety features of a full RDBMS. We'll go over the various schema-less data storage options in PostgreSQL, with a focus on the new JSON features. We'll talk about indexing, using JSON and other unstructured types in functions within PostgreSQL, and performance considerations.

In this DevOps world, developers are increasingly being asked to manage the database as well. In a few brisk minutes, we will talk about (nearly) everything you need to know to bring up, tune, and keep a PostgreSQL database health. We'll go over installation, basic tuning, backups, disaster recovery, and helpful tools and techniques. It's a very rare startup these days that has a full-time DBA on staff; mostly, the developers are pressed into service to handle the database as well. In this talk, we'll present the survival skills required to manage your PostgreSQL database while trying to push the product out the door. We'll cover: Installation. Basic tuning (it's easier than you think). Performance, including things you must not do. Backups and disaster recovery. Helpful tools, tips and tricks.

This talk goes into depth in writing and using custom types in PostgreSQL using Python and everything that can go wrong.

Using the postgreSQL specific features in database agnostic Django.

In this DevOps world, Django programmers are increasingly being asked to manage the database as well. In 45 brisk minutes, we will talk about (nearly) everything you need to know to bring up, tune, and keep a PostgreSQL database health. We'll go over installation, basic tuning, backups, disaster recovery, and helpful tools and techniques.

The Python web framework Django can handle extremely high levels of traffic... with appropriate design and support. We'll go over techniques to keep your Django site from being crushed under high load. Topics include: Schema/model design; Caching; Efficient view function design; Caching; Template design for high performance; Caching; Database tuning and sharding; Caching We'll also discuss caching.

In this one intense tutorial, we'll go from a bare machine with just a PostgreSQL source tarball or RPM in hand to a fully-functional, replicated, backed-up, tuned database installation. We'll cover: Installing the base PostgreSQL package and important additional modules; How to lay out the installation and the various components of PostgreSQL in the right places in the file system; Basic PostgreSQL tuning and optimization for particular hardware.; Getting PostgreSQL streaming replication/hot standby set up.; Doing backups; Monitoring and performance checking once your database is in production; Disaster planning and recovery. Only basic system administration experience is required; if you can type commands into bash, you're qualified.

A guide to the basics of PostgreSQL for non-DBAs managing their system.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.

Working with your database when it was populated and created with an ORM. This talk goes into what an ORM is, what is involved with it and how to best utilize it.