No upcoming presentations...

    Many schedulers for PostgreSQL have come and gone. When pg_timetable was developed we tried to learn from past mistakes and build a scheduler that is powerful and which can last. It offers every feature needed in the real world and offers a new approach to scheduling in PostgreSQL. Let us dive in and find out what it can do to provide an even better user experience.

    @ South Africa 2021

    Oct 5 2021

    Development

    CYPEX is a user-friendly tool to quickly build PostgreSQL applications. Little coding is needed to achieve big results – which makes it one of the fastest development tools for PostgreSQL. Traditional application development has taken a lot of precious time which is not feasible anymore. Empower professional developers and enable everyone else in your organization to be a part of the solut...

    @ Postgres Webinar Series

    Nov 10 2020

    Dev

    PostgreSQL performance from the ground up

    Because database speed matters

    Are you facing performance problems? Well, if you do this is the perfect training class for you. You will be guided through PostgreSQL performance from the ground up and learn how to optimize your PostgreSQL database to achieve maximum performance under all circumstances. We will also point you to the most common bottlenecks and provide easy solutions to those problems.

    @ Postgres Conference 2020
    Ops and Administration

    PostgreSQL TDE: Fully encrypted PostgreSQL

    Building more secure databases

    PostgreSQL TDE is a version of PostgreSQL which fully supports "Data At Rest Encryption". All data will be encrypted on disk and therefore PostgreSQL TDE offers additional layers of security which can hardly be achieved with standard PostgreSQL. PostgreSQL TDE is Open Source and can be used free of charge. You will learn how it works and what can be achieved at which kind of performance impac...

    @ Postgres Conference 2020
    Ops and Administration

    Kubernetes is a great place to run many services that requires automatisation and scale. By running Postgresql database on Kubernetes one can create uniformly managed, claud-native deployments with the flexibility to deploy postgresql as a service. Operator allows you to provide additional cotext to manage stateful application. An Operator also helps us with actions including provisioning...

    @ Postgres Digital Training Series

    PostgreSQL security is an important topic and the database offers a variety of features to protect your data. This training will teach you security from the ground up and cover aspects such as network security, authentication, database side permissions, row level security, security barriers as well as some additional tooling. At the end of the day you will be able to configure and manage a pro...

    @ South Africa 2019

    Oct 9 2019

    Ops and Administration

    Your database is performing badly but you got no idea why. Fortunately PostgreSQL has all the means to figure out what is really going on inside your database. You just have to find the right modules and use the right tools and understand what PostgreSQL is really trying to tell you. This talk will show you how to track down slow queries using pg_stat_statement, work with "explain analyze" and...

    @ South Africa 2019

    Oct 9 2019

    Ops and Administration

    PostgreSQL performance in 5 minutes

    Speeding up your database

    Are you suffering from bad performance? Is your database slow and does not satisfy your needs? In this case you should consider using a standard approach to improving performance. During this talk you will learn how to tune your database, detect bottlenecks and to find the most common problems. Find out how to speed up your system and learn all about PostgreSQL performance.

    @ South Africa 2019

    Oct 8 2019

    Ops and Administration

    Your database is performing badly but you got no idea why. Fortunately PostgreSQL has all the means to figure out what is really going on inside your database. You just have to find the right modules and use the right tools and understand what PostgreSQL is really trying to tell you. This talk will show you how to track down slow queries using pg_stat_statement, work with "explain analyze" and...

    @ Silicon Valley 2019

    Sep 18 2019

    Ops and Administration

    Are you suffering from bad performance? Do you have the feeling that your database can do a lot better? Well, maybe it really can. This talk will provide you with a simple guideline to ensure superior database performance using a systematic approach to tuning and especially to performance analysis. You will learn to find missing indexes (which will help to cut performance problems in half), fin...

    @ Silicon Valley 2019

    Sep 19 2019

    Ops and Administration

    What does the query optimizer really do? Is it magic? Is it Voodoo? What is really going on there? And what does all this "cost thing" really mean? Well, let us dive into the optimizer and find out, what is really going on deep inside the planner. You will be guides through the basic optimization and learn how the optimizer calculates costs, prunes joins, handles parallel queries, flattens subs...

    @ Silicon Valley 2019

    Sep 19 2019

    Dev

    Are you suffering from bad performance? That might not be necessary. A simple and easy approach can help to sort out many performance problems fast and efficiently. By using a systematic approach many nasty issues can be solved and users can be kept happy. During this talk you will learn to systemmatically approach a system and make it fast again.

    @ Postgres Conference

    Mar 20 2019

    Data

    Everybody is talking about Big Data and about processing large amounts of data in real time or close to real time. However, to process a lot of data there is no need for commercial software or for some NoSQL stuff. PostgreSQL can do exactly what you need and process A LOT of data in real time. During our tests we have seen that crunching 1 billion rows of data in realtime is perfectly feasible,...

    @ PGConf US 2017 [PgConf.US]

    Mar 30 2017

    Use Cases

    Are you facing bad performance? maybe you are not sure how to approach performance problems systematically? This training is what you have been looking for. During this training you will learn: - How to detect performance problems - Tracking down slow queries - Hunting I/O problems - Optimizing postgresql.conf for speed - Optimizing storage - Finding slow stores procedures - Playing with lockin...

    @ PGConf US 2017 [PgConf.US]

    Mar 28 2017

    Training

    Digging into advanced SQL

    Analyzing huge amount of data with super efficient modern SQL

    While SQL is a really powerful thing, most people don't harvest the full potential of the language. The idea of this training is to introduce people to some of the more advanced features of PostgreSQL such as windowing functions and analytics, ordered set, recursive SQL, and a lot more. This full day training will introduce you to all the advanced stuff you might have never heard of but which...

    @ PostgresConf US 2018
    Development

    ora_migrator: Moving from Oracle to PostgreSQL

    A new tool to move to PostgreSQL

    Moving from Oracle to PostgreSQL has become some sort of national sports. A couple of tools have already been developed to make the move to PostgreSQL easier. However, as none of the tool the tools really satisfied and therefore we came up with ora_migration, a tool, which allows to migrate data and other stuff to PostgreSQL fast and easily.

    @ PostgresConf US 2018

    Apr 19 2018

    Use Cases