PGConf Local: Seattle [PgConf.US] Program

presented by Robert Bernier

**Download workshop materials here: https://gitlab.com/fV6Dcb8VGcpyI/PostgreSQL_and_Linux_Containers_in_the_Enterprise**

EXPERIENCE LEVEL: Expert

SESSION TRACK: Infrastructure

DETAILS: COURSE DESCRIPTION: Automation is THE big thing these days. Software delivery and infrastructure changes in regards to provisioning, creating and tearing down servers, is no longer a nich...

presented by Kevin Kempter

We'll discuss architecture and scaling to include:

• monitoring & "Monthly DB Reports"
• backup / recovery
• replication & HA
• DR sites and connection pooling
• Capacity planning & metrics
• Scaling
• Ongoing Architecture Monitoring & Lifecycle

presented by Jennifer Scheuerell

For the last two years, Sound Data has been developing a PostgreSQL + Django application for the California Public Utility Commission (CPUC) to securely manage their $1B per year investment in energy efficiency and demand side management. The application is known as the California Energy Data and Reporting System (Cedars), and manages data reporting for three different reporting requirements fo...

presented by Haikal Pribadi

**Update 11/13/2017 Cancelled due to illness*

Cognitive/AI systems process knowledge that is far too complex for current databases. They require more expressive data schemas and intelligent query languages to provide a strong abstraction over complex data and their relationships. In this talk, we will discuss how GRAKN.AI, a distributed hyper-relational database, enables knowledge-oriented...

presented by Jim Mlodgenski

One of the great features of PostgreSQL is its pluggable language handler allowing many different types of stored procedure languages including JavaScript aka PL/V8. This allows web developers to leverage their existing coding skills when writing database sever-side code. In this talk we will discuss:

• How to create a PL/V8 function
• Interacting with database objects
• Returning results ...

presented by Matvey Arye

Today everything is instrumented, generating more and more time-series data streams that need to be monitored and analyzed. When it comes to storing this data, many developers often start with some well-trusted system like PostgreSQL, but when their data hits a certain scale, give up its query power and ecosystem by migrating to some NoSQL or other "modern" time-series architecture. They face t...

presented by Jignesh Shah

More companies are now providing managed PostgreSQL services. We look at some basic features of managed PostgreSQL services in the cloud. Understanding such services allow us to better use these services for our applications. We also look at typical best practices for the normal DBA activities on these managed services.

presented by David Wein

In this session we will cover a number of the way that you can tune PostgreSQL to better handle high write workloads. We will cover both application and database tuning methods as each type can have substantial benefits but can also interact in unexpected ways when you are operating at scale. On the application side we will look at write batching, use of GUID's, general index structure, the c...

presented by Jim Nasby

The use of Multi-Version Concurrency Control (MVCC) is perhaps one of the most powerful features PostgreSQL has to offer, but it can be a source of confusion for new and experienced users alike. In this talk we will provide an in-depth walkthrough of why Postgres needs to vacuum and what vacuum does.

Topics

• MVCC details
• HOT overview
• Identifying tuples to be vacuumed/frozen
• ...

presented by Lloyd Albin

In this presentation we will go over the old school math and the new school PostGIS method of doing the same math for calculating the distance and cost of an aircraft flight. You will notice how much easier it is to use PostGIS.

• Installing PostGIS
  • Cloud Solutions
  • From Source
• Aviation Math
  • Airplane Performance
  • Great Circle Math
• PostGIS Math
  • Updating your table...