Канал: Postgres Conference

Learning PostgreSQL

Learning PostgreSQL

Building GenAI Applications with PostgreSQL and Google Cloud's AlloyDB Omni

Building GenAI Applications with PostgreSQL and Google Cloud's AlloyDB Omni

NYC Postgres Meetup Livestream: Postgres Automation and Hyperscaling

NYC Postgres Meetup Livestream: Postgres Automation and Hyperscaling

Advanced Strategies for PostgreSQL Lock Management

Advanced Strategies for PostgreSQL Lock Management

Data Isolation in Multitenant PostgreSQL

Data Isolation in Multitenant PostgreSQL

PostgresWorld Presents: A Live Digital Privacy Event with EFF & The More than a Refresh Podcast

PostgresWorld Presents: A Live Digital Privacy Event with EFF & The More than a Refresh Podcast

Future of Postgres Ecosystem Roundtable

Future of Postgres Ecosystem Roundtable

Functions and Procedures: Use and Misuse

Functions and Procedures: Use and Misuse

Episode 2: Accelerating Build Feedback

Episode 2: Accelerating Build Feedback

YugabyteDB Distributed PostreSQL: Why and How?

YugabyteDB Distributed PostreSQL: Why and How?

What Next in Logical Replication

What Next in Logical Replication

Past, Present, and Future of Logical Replication

Past, Present, and Future of Logical Replication

The NOSQL Store that Everyone Ignored

The NOSQL Store that Everyone Ignored

Long Queries and the Art of Full Scan

Long Queries and the Art of Full Scan

Power use of Indexes in PostgreSQL - A user perspective.

Power use of Indexes in PostgreSQL - A user perspective.

Reducing Costs and Improving Performance with Data Modeling in Postgres

Reducing Costs and Improving Performance with Data Modeling in Postgres

Aggregates in PGX: An Adventure

Aggregates in PGX: An Adventure

CRUD Functions Generator Tool

CRUD Functions Generator Tool

Developer Productivity Engineering

Developer Productivity Engineering

Store and Analyze Petabyte Scale Time Series Data

Store and Analyze Petabyte Scale Time Series Data

Timestamps, timezones, and interval arithmetic

Timestamps, timezones, and interval arithmetic

Episode 1: Introducing Developer Productivity Engineering

Episode 1: Introducing Developer Productivity Engineering

Hadoop Can’t Query? PostgreSQL Features

Hadoop Can’t Query? PostgreSQL Features

Episode 3: Accelerating Test Execution

Episode 3: Accelerating Test Execution

Beyond Off-the-Shelf Consensus

Beyond Off-the-Shelf Consensus

Building a PostgreSQL Backed Website Quickly

Building a PostgreSQL Backed Website Quickly

Evolution of Partitioning Features

Evolution of Partitioning Features

Timestamps, timezones, and interval arithmetic

Timestamps, timezones, and interval arithmetic

Will Postgres Live Forever?

Will Postgres Live Forever?

Using the PostgreSQL recursive CTE to compute Bacon numbers for actors listed in the IMDb

Using the PostgreSQL recursive CTE to compute Bacon numbers for actors listed in the IMDb

Database Too Big to Query?

Database Too Big to Query?

How to Build Local Communities: A Meetup Perspective

How to Build Local Communities: A Meetup Perspective

Logical Replication Lessons Learned for the Data Warehouse

Logical Replication Lessons Learned for the Data Warehouse

NORM - Bridging the Gap Between Applications and Databases

NORM - Bridging the Gap Between Applications and Databases

PGX: Build Postgres Extensions with Rust

PGX: Build Postgres Extensions with Rust

Introduction to PostgreSQL ColumnStore Indexes

Introduction to PostgreSQL ColumnStore Indexes

Database Isolation Levels, Data Issues, and Global Transaction Consistency

Database Isolation Levels, Data Issues, and Global Transaction Consistency

All About PostgreSQL's Security

All About PostgreSQL's Security

Using PostgreSQL and Friends for a Street Sweeping Solver Project

Using PostgreSQL and Friends for a Street Sweeping Solver Project

CYPEX: Rapid Application Building

CYPEX: Rapid Application Building

Data Processing More Than a Billion Rows per Second

Data Processing More Than a Billion Rows per Second

Monitoring Strategy Considerations

Monitoring Strategy Considerations

Demo: Creating A Single Point Of Access To Multiple Postgres Servers Using Starburst Presto

Demo: Creating A Single Point Of Access To Multiple Postgres Servers Using Starburst Presto

Real-Time Machine Learning on PostgreSQL vs MongoDB

Real-Time Machine Learning on PostgreSQL vs MongoDB

How to Query Against Multiple Postgres Instances as if They're One Server Using Starburst Presto

How to Query Against Multiple Postgres Instances as if They're One Server Using Starburst Presto

Turning PostgreSQL Into a Cloud Native Data Service

Turning PostgreSQL Into a Cloud Native Data Service

Deep Dive Into PostgreSQL Indexes

Deep Dive Into PostgreSQL Indexes

Enterprise Authentication and Connection Pooling

Enterprise Authentication and Connection Pooling

PostgreSQL Replication Digital Training

PostgreSQL Replication Digital Training

How to Move Data from Oracle to Postgres in Near Real Time

How to Move Data from Oracle to Postgres in Near Real Time

How to Move Data from Oracle to Postgres in Near Real Time

How to Move Data from Oracle to Postgres in Near Real Time

Deeper Understanding of PostgreSQL Execution Plan: At Plan Time and Run Time

Deeper Understanding of PostgreSQL Execution Plan: At Plan Time and Run Time

Intro to PostGIS and OpenStreetMap

Intro to PostGIS and OpenStreetMap

FPGA: An Easier Path to Parallelism for Postgres?

FPGA: An Easier Path to Parallelism for Postgres?

Build to Adapt: Co-Chair "JD" and PostgresConf

Build to Adapt: Co-Chair "JD" and PostgresConf

Bring Compression to Postgres at Zero Cost of Performance

Bring Compression to Postgres at Zero Cost of Performance

PgPool II Performance and best practices

PgPool II Performance and best practices

How to Deploy a Cloud Native Database on Kubernetes

How to Deploy a Cloud Native Database on Kubernetes

Postgres Conference 2019: Diversity and Inclusion Panel (Part 1)

Postgres Conference 2019: Diversity and Inclusion Panel (Part 1)

PostgreSQL Parallelism Do’s and Don’ts

PostgreSQL Parallelism Do’s and Don’ts

Loading PostGIS with osm2pgsql

Loading PostGIS with osm2pgsql

Mostly Mistaken and Ignored PostgreSQL Parameters while Optimizing a PostgreSQL Database

Mostly Mistaken and Ignored PostgreSQL Parameters while Optimizing a PostgreSQL Database

Community vs Enterprise Open Source Which is Right for your Business

Community vs Enterprise Open Source Which is Right for your Business

The Architecture of a Geo Distributed Database

The Architecture of a Geo Distributed Database

PostgreSQL 12 and PostGIS 3

PostgreSQL 12 and PostGIS 3

Working with JSON in PostgreSQL vs MongoDB

Working with JSON in PostgreSQL vs MongoDB

Debugging with PostgreSQL A Strategic Approach

Debugging with PostgreSQL A Strategic Approach

A Deep Dive Into PostgreSQL Indexes

A Deep Dive Into PostgreSQL Indexes

PostGIS Advanced Vector Operations

PostGIS Advanced Vector Operations

Yugabyte: A Distributed PostgreSQL Database

Yugabyte: A Distributed PostgreSQL Database

Scaling PostgreSQL: Never Shard Again and Gain Effortless Scale

Scaling PostgreSQL: Never Shard Again and Gain Effortless Scale

Exploring OpenStreetMan Data in PostGIS: Tools and Queries

Exploring OpenStreetMan Data in PostGIS: Tools and Queries

PostGIS Spatial Queries and Performance Tuning

PostGIS Spatial Queries and Performance Tuning

Provisioning and Automating High Availability Postgres on AWS EC2

Provisioning and Automating High Availability Postgres on AWS EC2

Amazon RDS or How I Learned to Stop Worrying and Love the Cloud

Amazon RDS or How I Learned to Stop Worrying and Love the Cloud

Schema management with Flyway

Schema management with Flyway

Workshop Logical Replication Deep Dive

Workshop Logical Replication Deep Dive

Top 10 Problems Solved by PostGIS

Top 10 Problems Solved by PostGIS

Managing OS Provided PostgreSQL Packages

Managing OS Provided PostgreSQL Packages

Moving PostgreSQL Forward

Moving PostgreSQL Forward

ProstgreSQL BI Performance & News from XL Project

ProstgreSQL BI Performance & News from XL Project

Timescale DB Designing a Scalable Time Series Database on PostgreSQL

Timescale DB Designing a Scalable Time Series Database on PostgreSQL

Next Generation Parallel Query

Next Generation Parallel Query

Lessons Learned Migrating to PostgreSQL

Lessons Learned Migrating to PostgreSQL

PostgreSQL on Google's Cloud SQL

PostgreSQL on Google's Cloud SQL

Logical Replication in PostgreSQL 10

Logical Replication in PostgreSQL 10

600k Queries per Second in PostgreSQL We Do it in TomTom

600k Queries per Second in PostgreSQL We Do it in TomTom

Security Enhancements in PostgreSQL 10

Security Enhancements in PostgreSQL 10

Exploiting the Hidden Talents of JDBC for Maximum Performance

Exploiting the Hidden Talents of JDBC for Maximum Performance

Keynote AWS

Keynote AWS

Advanced Postgres Monitoring

Advanced Postgres Monitoring

Keynote The Power of Convenience

Keynote The Power of Convenience

Restrictions on PostgreSQL Cloud DBaaS

Restrictions on PostgreSQL Cloud DBaaS

Migrating off of MongoDB to PostgreSQL

Migrating off of MongoDB to PostgreSQL

Evolution of pgAdmin pgAdmin4

Evolution of pgAdmin pgAdmin4

Processing 1 Billion Rows Per Second

Processing 1 Billion Rows Per Second

ETL Confessions

ETL Confessions

A Practical Postgres Protocol Primer

A Practical Postgres Protocol Primer

How Green Was My Valley

How Green Was My Valley

TOASTing an Elephant Building a Custom Data Warehouse Using PostgreSQL

TOASTing an Elephant Building a Custom Data Warehouse Using PostgreSQL

Corruption War Stories

Corruption War Stories

The Dark Side of the Universe from Oracle to PostgreSQL

The Dark Side of the Universe from Oracle to PostgreSQL

Implementing Graph Database based on PostgreSQL

Implementing Graph Database based on PostgreSQL

Designing your SaaS Database for Scale with Postgres

Designing your SaaS Database for Scale with Postgres

Patroni HA PostgreSQL Made Easy

Patroni HA PostgreSQL Made Easy

Enterprise Data Architecture with PostgreSQL

Enterprise Data Architecture with PostgreSQL

Speeding up Query Execution

Speeding up Query Execution

Amazon RDS for PostgreSQL What's New and Lessons Learned

Amazon RDS for PostgreSQL What's New and Lessons Learned

Transitioning from MSSQL to PostgreSQL, our Trials and Tribulations

Transitioning from MSSQL to PostgreSQL, our Trials and Tribulations

JSON in Postgres The Present and Future

JSON in Postgres The Present and Future

Iago High Availability Postgres using etcd

Iago High Availability Postgres using etcd

DevOps Tools for Managing PostgreSQL

DevOps Tools for Managing PostgreSQL

Lessons Learned the Hard Way Postgres in Production at GoCardless

Lessons Learned the Hard Way Postgres in Production at GoCardless

Audit Logging with PostgreSQL

Audit Logging with PostgreSQL

PostgreSQL High Availability in a Containerized Worled

PostgreSQL High Availability in a Containerized Worled

Tour de Data Types VARCHAR2 or CHAR255

Tour de Data Types VARCHAR2 or CHAR255

Peeking into the Black Hole

Peeking into the Black Hole

Identifying Slow Queries, and Fixing Them!

Identifying Slow Queries, and Fixing Them!

Gophers Riding Elephants Writing PostgreSQL Tools in Go

Gophers Riding Elephants Writing PostgreSQL Tools in Go

LXD The Container Hypervisor

LXD The Container Hypervisor

Intro to PostgreSQL

Intro to PostgreSQL

Designing the Right Schema to Power Heap

Designing the Right Schema to Power Heap

Columns and Clouds Hybrid Databases

Columns and Clouds Hybrid Databases

Sort vs Hash A Duality

Sort vs Hash A Duality

Apache Ignite SQL Grid Turbocharge Your SQL Queries in Memory

Apache Ignite SQL Grid Turbocharge Your SQL Queries in Memory

All the Dirt on VACUUM 9

All the Dirt on VACUUM 9

MVCC Unmasked

MVCC Unmasked

Analytics Infrastructure Powered by Logical Decoding and Kafka

Analytics Infrastructure Powered by Logical Decoding and Kafka

ABC's of PostgreSQL Backups

ABC's of PostgreSQL Backups

Pgcrypto avast! A Case Study in Django's Password Hashers

Pgcrypto avast! A Case Study in Django's Password Hashers

PostgreSQL Worst Practices

PostgreSQL Worst Practices

POWER Platform The New Home for PostgreSQL

POWER Platform The New Home for PostgreSQL

In Core Compression

In Core Compression

A look at the Elephants trunk PostgreSQL 9 6 Magnus Hagander

A look at the Elephants trunk PostgreSQL 9 6 Magnus Hagander

Achieving a State of Flow Continuous Integration and Practical Event Sourcing w PostgreSQL Paolo

Achieving a State of Flow Continuous Integration and Practical Event Sourcing w PostgreSQL Paolo

Amazon RDS for PostgreSQL Deep Dive on New Features and Learnings Grant McAlister

Amazon RDS for PostgreSQL Deep Dive on New Features and Learnings Grant McAlister

Analysis in CartoDB

Analysis in CartoDB

Citus Architecture Extending Postgres to Build

Citus Architecture Extending Postgres to Build

Data Integration in the World of Microservices Valentine Gogichashvili

Data Integration in the World of Microservices Valentine Gogichashvili

Deep Dive into PostgresSQL Statistics

Deep Dive into PostgresSQL Statistics

Deploying and Managing PostgreSQL with Ansible David Hollenberger mp4

Deploying and Managing PostgreSQL with Ansible David Hollenberger mp4

Efficiently Backing up Terabytes of Data with pgBackRest David Steele

Efficiently Backing up Terabytes of Data with pgBackRest David Steele

ESA Sky New window to the stars using PostgreSQL Pilar de Teodoro

ESA Sky New window to the stars using PostgreSQL Pilar de Teodoro

HA PostgreSQL cluster with repmgr and pgbouncer Jaime Casanova

HA PostgreSQL cluster with repmgr and pgbouncer Jaime Casanova

HawkEye On Postgresql Adarsh Sharma

HawkEye On Postgresql Adarsh Sharma

How PostgreSQL is tested

How PostgreSQL is tested

How Tencent uses Postgres XC for their high volume WeChat payment system Jasonys Li mp4

How Tencent uses Postgres XC for their high volume WeChat payment system Jasonys Li mp4

How we made Greenplum Open Source Andreas Scherbaum

How we made Greenplum Open Source Andreas Scherbaum

IO in Postgres Architecture, Tuning, Problems Andres Freund

IO in Postgres Architecture, Tuning, Problems Andres Freund

Kicking the Donkey of PostgreSQL Replication Joshua D Drake

Kicking the Donkey of PostgreSQL Replication Joshua D Drake

Lessons Learned Operating Postgres at Scale Dave Pirotte

Lessons Learned Operating Postgres at Scale Dave Pirotte

Migrating a live Postgres database into RDS with no downtime Experiences and Lessons Learned David

Migrating a live Postgres database into RDS with no downtime Experiences and Lessons Learned David

MLS PostgreSQL Implementing Multi level Security in PostgreSQL with RLS and SELinux Joe Conway mp4

MLS PostgreSQL Implementing Multi level Security in PostgreSQL with RLS and SELinux Joe Conway mp4

On Providing Scalable Managed PostgreSQL services to Cloud Foundry Xiujiao Gao mp4

On Providing Scalable Managed PostgreSQL services to Cloud Foundry Xiujiao Gao mp4

Overcoming First Principles A guide for accessing the features of PostgreSQL in test driven develop

Overcoming First Principles A guide for accessing the features of PostgreSQL in test driven develop

Parallel Query In PostgreSQL Robert Haas

Parallel Query In PostgreSQL Robert Haas

PostgreSQL Java Past Present and Future Alvaro Hernandez

PostgreSQL Java Past Present and Future Alvaro Hernandez

PostgreSQL DevOps with Chef & Puppet Scott Mead

PostgreSQL DevOps with Chef & Puppet Scott Mead

PostgreSQL HA Database Clusters through Containment QUAN HA LE mp4

PostgreSQL HA Database Clusters through Containment QUAN HA LE mp4

PostgreSQL High Availability and Geographic Locality using consul Sean Chittenden

PostgreSQL High Availability and Geographic Locality using consul Sean Chittenden

PostgreSQL in the Polyglot Enterprise Mitch Pirtle

PostgreSQL in the Polyglot Enterprise Mitch Pirtle

PostgreSQL Monitoring Kevin Kempter

PostgreSQL Monitoring Kevin Kempter

PostgreSQL Performance Presentation, 9 6devel Edition Mark Wong

PostgreSQL Performance Presentation, 9 6devel Edition Mark Wong

PostgreSQL Power on Power Michael Meskes

PostgreSQL Power on Power Michael Meskes

PostgreSQLs secret NoSQL superpowers Amanda Gilmore mp4

PostgreSQLs secret NoSQL superpowers Amanda Gilmore mp4

PostgresSQL Development

PostgresSQL Development

Practical Lessons Learned when using PostgreSQL at a Web Startup Lukas Fittl

Practical Lessons Learned when using PostgreSQL at a Web Startup Lukas Fittl

Predictive Analytics IN Postgres Jim Nasby

Predictive Analytics IN Postgres Jim Nasby

Programming the SQL Way with Common Table Expressions Bruce Momjian mp4

Programming the SQL Way with Common Table Expressions Bruce Momjian mp4

PubSub with Postgresql Gian Biondi

PubSub with Postgresql Gian Biondi

Ranges, Partitioning and Limitations Corey Huinker mp4

Ranges, Partitioning and Limitations Corey Huinker mp4

Sorting Through the Ages Gregory Stark

Sorting Through the Ages Gregory Stark

SQL and MongoDB how PostgreSQL brought them together Asya Kamsky

SQL and MongoDB how PostgreSQL brought them together Asya Kamsky

That SQL looks pretty complicated Where are the tests James E Marca mp4

That SQL looks pretty complicated Where are the tests James E Marca mp4

Top 10 Problems Solved by PostGIS Leo Hsu

Top 10 Problems Solved by PostGIS Leo Hsu

Using PostgreSQL to manage ArcGIS spatial data

Using PostgreSQL to manage ArcGIS spatial data

You'd better have tested backups - Dimitri Fontaine

You'd better have tested backups - Dimitri Fontaine

A TARDIS for your ORM - application level time travel in PostgreSQL

A TARDIS for your ORM - application level time travel in PostgreSQL

Amazon RDS for PostgreSQL - What's new and lessons learned

Amazon RDS for PostgreSQL - What's new and lessons learned

Building a 'Database of Things' with Foreign Data Wrappers

Building a 'Database of Things' with Foreign Data Wrappers

Fun with Functions, by Example

Fun with Functions, by Example

The Image of Postgres

The Image of Postgres

Fashion Is Hard. PostgreSQL Is Easy.

Fashion Is Hard. PostgreSQL Is Easy.

cstore_fdw: Columnar store for PostgreSQL

cstore_fdw: Columnar store for PostgreSQL

Citus Data: Scale out PostgreSQL

Citus Data: Scale out PostgreSQL

Challenges in Moving a Postgres DBaaS to OpenStack

Challenges in Moving a Postgres DBaaS to OpenStack

Advanced use of pg_stat_statements: Filtering, Regression Testing & More

Advanced use of pg_stat_statements: Filtering, Regression Testing & More

Riggs, Then Beer

Riggs, Then Beer

Poor Man's Parallel Processing

Poor Man's Parallel Processing

Monitoring Postgres from the ground up: the metrics that matter

Monitoring Postgres from the ground up: the metrics that matter

Rank Your Results: Using Full Text Search with Natural Language Queries to get Ranked Results

Rank Your Results: Using Full Text Search with Natural Language Queries to get Ranked Results

Scale-out PostgreSQL with Postgres-XL

Scale-out PostgreSQL with Postgres-XL

How does PostgreSQL work with disks: a DBA’s checklist in detail

How does PostgreSQL work with disks: a DBA’s checklist in detail

Vitesse DB: 100% PostgreSQL, 100 Times Faster for Analytics

Vitesse DB: 100% PostgreSQL, 100 Times Faster for Analytics

Shootout at the AWS Corral

Shootout at the AWS Corral

At The Heart Of A Giant: Postgres At TripAdvisor

At The Heart Of A Giant: Postgres At TripAdvisor

ALTER DATABASE ADD more SANITY

ALTER DATABASE ADD more SANITY

Think Your Postgres Backups And Disaster Recovery Are Safe? Let's talk.

Think Your Postgres Backups And Disaster Recovery Are Safe? Let's talk.

PostgreSQL - Community meets Business

PostgreSQL - Community meets Business

PostgreSQL Disaster Recovery with Barman

PostgreSQL Disaster Recovery with Barman