Amazon recently announced FPGA (https://en.wikipedia.org/wiki/Field-programmable_gate_array) acceleration for Redshift, most clouds now offer FPGA-equipped instances, and FPGA prices are dropping. Is it time for you to consider hardware acceleration for Postgres? Adding an FPGA processor to your free, open source Postgres server, along with the Swarm64 FPGA extension for Postgres, enhances your database with 100+ additional SQL reader & writer processes working in parallel to speed up...
This is the first of six (6) sessions covering how to find, load, and consume OpenStreetMap data using PostGIS and PostgreSQL. This session covers what PostGIS and OpenStreetMap are, and why they are important in our modern world. No prior experience with PostGIS or OpenStreetMap is required for this introductory session. The session recording and links shown are available at: https://blog.rustprooflabs.com/2020/01/webinar-intro-postgis-openstreetmap
Replicating live data (thousands of events per second) from Oracle to Postgres doesn’t have to be difficult. But the latency and complexity of traditional solutions, such as ETL, legacy CDC and homegrown scripts, have proven to be costly and inefficient. When you are replicating live data from one data platform to another, the process should be simple, inexpensive and as near real time as possible in order to provide a positive impact on decision making and reporting. The Equalum approach...
This session dives into how to install, configure and use osm2pgsql on Linux to load OpenStreetMap data into PostGIS. Loading the data into PostGIS is the first step required to begin consuming and leveraging OpenStreetMap data. Where to download OSM data, best practices, helpful tricks and common pitfalls are all covered.
This session introduces the tools, concepts and basic queries needed for working with spatial data stored in PostGIS. Building on the prior session, this session illustrates how to query and visualize OpenStreetMap data loaded to PostGIS. Tools discussed in this session include GUI software as well as on-line resources for learning more about OpenStreetMap's Key/Value data structure.
This final session focuses on PostGIS, scratching the surface of a range of the advanced operations PostGIS is capable of. Preparing data in a different formats (GeoJSON, MVT) for external dependencies, 3D rendering, and routing are some of the topics covered.
This session is a deep dive into complex spatial queries and performance tuning with PostGIS. Common performance headaches are explored with a variety of approaches to remedy. GIST indexes, proper data modeling, and materialized views are demonstrated.
PostgreSQL 12 and PostGIS 3.0 bring an amazing plethora of improvements to PostGIS-enabled databases. This session highlights a number of reasons to upgrade to the latest and greatest versions! Parallel query improvements, generated columns and covering GIST indexes are some of the highlights.
Join us in learning all about Enterprise Connection Pooling and Authentication with Postgres! In this digital breakout session you will learn how to: Reduce Postgres resource utilization with with per user and global connection pooling limits. Simplify database access management with 1) Active Directory and LDAP and 2) Group extraction for Postgres.
has the most awesome program ever!
See rock-star speakers cover the topics of
How to Move Data from Oracle to Postgres in Near-Real Time by Joshua D. Drake
Getting Started with PostGIS and OpenStreetMap by Ryan Lambert
Loading PostGIS with osm2pgsql by Ryan Lambert
Exploring OpenStreetMap from PostGIS: Tools and Queries by Ryan Lambert
Advanced Operations and Features by Ryan Lambert
PostGIS Spatial Queries and Performance Tuning by Ryan Lambert
PostgreSQL 12 and PostGIS 3.0 by Ryan Lambert