Conference Highlights

Jan 26 All we need to work with SQL is just SQL

Traditionally, we use Languages and Frameworks interact with Relational Databases. While these are effective in many ways, One problem is that, each of these brings new learning curve. It will be nice if we use SQL itself as the core skill and build application with plain simple SQL skills. In this webinar, I will demo this approach with a case study that builds simple, high performing Java application using Postgres database.

Jan 27 PostgreSQL Forks and Knives

The number of PostgeSQL forks keeps growing. Some of them are really ancient, while others are relatively new. Redshift, Greenplum, Cockroach, Timescale, RDS, Vertica, you name it. All modern clouds have their own forks of traditional PostgreSQL. But are these databases our familiar PostgreSQL, or something absolutely different? DBeaver supports all the main PostgreSQL forks, and we can confidently say that it is really surprising to find unexpected differences or similarities. If...

Feb 03 Postgres for SQL Server Users

As Postgres gains popularity in the DBMS world, it has become a very attractive alternative for Microsoft SQL Server, allowing organizations that make the leap to take advantage of modern features while saving big money on software licensing. In this talk I will go over the top reasons to choose Postgres over SQL Server and outline a plan for performing such migrations. Key learnings: The main differences to consider when switching from SQL Server to Postgres Data type mappings...

Feb 04 Configuring PostgreSQL for Faster Analytic Query Performance

Are you using PostgreSQL for query-intensive applications like reporting and charting, analytics (OLAP/HTAP), or data warehousing? Join us on February 4 to learn straightforward ways to get the best possible query performance from PostgreSQL. Swarm64 Solution Architect, Sebastian Dressler, will cover proven PostgreSQL configuration tuning best practices that have helped PostgreSQL users significantly boost analytic query performance. Topics include: Configuring for parallel...

Feb 23 Blockchain as a Database

Throughout the history, exchange of trusted information among people played an essential role in every aspect of their lives: socially, economically and politically. Blockchain is an innovation in database technology for keeping temper proof (trusted) data in a permanent, immutable, decentralized, global, and trustless ledger. It combines distributed computing, databases, networks and cryptography and is relatively new, and it is rapidly evolving. It allows people, organizations and machines...

Mar 16 Debunking Indexing Myths in PostgreSQL

This webby will quickly take you through the journey of understanding and (subsequently) debunking the myths around the importance of indexing in improving database performance. We will look at the core indexes in addition to some extensions that might just make your applications blazing fast, if implemented right. This webby will cover: In-built index types in PostgreSQL 3rd-party indexing extensions Full-text searching with GIN index Attaching Elasticsearch to your...

Mar 23 PostgreSQL Autovacuum Tuning Lessons From The Field

Do you support the PostgreSQL database behind a demanding application? Do your users have queries that mysteriously get progressively slower over time and then run normally again without explanation? Is AutoVacuum working on a particular table(s) almost all the time? This presentation offers guidance on identifying good practices around monitoring AutoVacuum, how to approach tuning, and how to avoid the most common pitfalls I see during tuning exercises as a consultant in the field. In...

Mar 24 Boosting Amazon RDS PostgreSQL performance with a PG Nitrous Fast-Query Replica

Do you need faster Amazon RDS query performance? Need to scale end-user reporting and dashboarding in your RDS applications or add more complex analytics? Join us to learn about PG Nitrous, a new PostgreSQL cloud solution hosted on AWS EC2 by Swarm64. In this webinar we will demonstrate how to accelerate Amazon RDS PostgreSQL query performance by 30x by using PG Nitrous as a fast-query replica. Agenda: What's PG Nitrous? Using PG Nitrous as a fast-query replica for Amazon RDS...

Mar 30 Scaling Beyond Pg-Bouncer & Pg-Pool-II: Advanced Traffic Management

Database proxies intelligently manage Postgres connections to improve performance and scale. In this session, we will highlight deficiencies of Pg-bouncer and Pg-Pool-II that users should know, and propose solutions. Features to be discussed include: Connection pooling Read/write split with Strong Consistency Query caching Persisted connection, automated Postgres failover Active Directory / LDAP integration Includes live demo and Q&A

Mar 31 OpenStreetMap to PostGIS: Easier and Better!

This session will be a live demo to show how easy it is to import high quality OpenStreetMap data into PostGIS / Postgres. The long-used osm2pgsql tool has a new Flex output (Flex == "flexible") that has completely changed the game! This demo highlights how the osm2pgsql Flex output is being used by PgOSM-Flex (https://github.com/rustprooflabs/pgosm-flex) to provide a high quality "off-the-shelf" experience, and how it can be further customized to suit your geospatial data needs! The...

Apr 08 The Data Bottleneck - The Data Engineer And How We Are Trying To Fix This

Interview Query recently reported that the number of data engineering roles at companies continues to grow annually, where as surprisingly, the number of data scientists has shrank back in comparison. Data engineers spend much of their time building data pipelines and managing data warehouses, and there are lots of tools for data engineers to choose from when it comes to developing data pipelines. In this talk, we will discuss how in many companies currently, the data engineer is...

Apr 27 SQL for Time Series Using QuestDB

The nature of time series data means that 90% of the transactions occurring are new records being inserted, and queries are most likely to be recent time ranges. The Open Source QuestDB is optimized for this usage pattern. We have several features that provide high-performance inserts and reads over other PostgreSQL based Time Series solutions. This webinar covers how storage and ingestion work in QuestDB, how to use popular PostgreSQL clients with QuestDB, and why ANSI SQL is a perfect fit...

Program

Call for Papers

We are ready to accept your proposals for sessions!

You can submit proposals for Webinars and Webbies. Proposals should fit in one of the 2 tracks: Dev and Ops. The submission period has begun Tuesday, January 5. 2021 and closes Tuesday, November 30. 2021. That means you have only 275 days left! Remember 2021_Postgres_Conference_Webinars will only be as good as the sessions you present. Submit early, submit often!