All Day

Canada PGCon 2022

Join us for the 16th annual PGCon! PGCon is an annual conference for users and developers of PostgreSQL, a leading relational database, which just happens to be open source. PGCon is the place to meet, discuss, build relationships, learn valuable insights, and generally chat about the work you are doing with PostgreSQL. If you want to learn why so many people are moving to PostgreSQL, PGCon will be the place to find out why. Whether you are a casual user or you've been working with PostgreSQL for years, PGCon will have something for you. NOTE: This year, the conference will

DevOps Pro Europe 2022

Annual DevOps Pro Europe conference covers the core principles and concepts of the DevOps methodology and demonstrates how to use the most common DevOps patterns to develop, deploy and maintain applications on-premises and in the cloud. DevOps Pro Europe conference puts the spotlight on entire software delivery pipeline and the following domains: DevOps Approach Continuous Delivery, Continuous Integration, Configuration Management, Automated Testing and Deployment DevOps World Experience Technology Adoption, Real Life Implementation Examples, Best Practices and Insights from the Field DevOps Tools Docker, Chef, Puppet, PowerShell, Kubernetes, GitHub, Ansible, SaltStack, Capistrano, Jenkins DevOps Technologies Virtualization, Containerization, Orchestration, Microservices, Cloud Computing

Function calls in SQL – Black Box for the Optimizer?

Functions in SQL are a useful and popular feature that is often used. However, little attention is often paid to performance aspects. A function call or an expression in a WHERE condition is a challenge for the query optimizer that often leads to unsuitable execution plans and bad response times. For PL/SQL functions called from SQL, the situation is even more complex. If used incorrectly, they can lead to massive performance degradation. In this presentation, I will show different possibilities to support the optimizer in function calls to generate better execution plans. Furthermore, I will explain how PL/SQL functions can