In our webcast “Turn the Tables on Poor Database Performance”, SolarWinds database expert, Kevin Kline, met with Kellyn Gorman, director of data and AI at Silk. Together they discussed one of the most popular opensource databases on the market—PostgreSQL. For anyone new to working with PostgreSQL, or struggling to understand how to maximize return on time invested in this versatile database solution, Kevin and Kellyn provide a variety of critical insights into query efficiency and table indexing on PostgreSQL, covering topics such as:
- Configuration parameter tuning for better memory management
- Assessing query inefficiencies by reading execution plans
- Reviewing table and index design for optimal performance
- Reviewing workloads to determine the right options to tune first
Kevin has over 35 years of experience as a developer, data scientist, DBA, enterprise architect, and IT manager, with over a dozen books to his credit. Kellyn has over 25 years of experience as a database specialist (Oracle, SQL Server, and other database platforms). Kellyn has authored many books and technical papers, and in the DBA world is known for her content under the social media handle, DBAKevlar.
Watch the Full Webinar on BrightTALK
A Brief Introduction to PostgreSQL
For companies looking for a robust open-source database solution, PostgreSQL provides reliable and flexible, future-proof capabilities. PostgreSQL adheres to the ANSI/ISO standards for the SQL language and thrives off community commitment to steady, incremental improvement. Because the PostgreSQL source code (written in the C programming language) is available under an open-source license, users are free to change and implement it to their own requirements and technical specifications.
PostgreSQL can be installed on all major operating systems and is flexible enough to handle workloads in applications ranging from single machines to large internet-facing deployments, whether on-premises or in the cloud. Because it fits squarely in the enterprise-grade database management world but has all the advantages of an open-source offering, PostgreSQL is a very good choice for scalable database management.
Learn more about PostgreSQL
To match the rise of PostgreSQL, SolarWinds Database Performance Analyzer (DPA) now includes comprehensive database performance analytics for PostgreSQL—including on EDB, Microsoft Azure, Amazon RDS, Amazon Aurora, and Google Cloud SQL. If you’re already using PostgreSQL (or are considering migrating from Oracle or SQL Server to PostgreSQL), the latest version of DPA ships with three powerful PostgreSQL tuning advisors:
- Query advisors: Provide performance information on specific queries. For example, wait time, sessions info, execution plans, etc.
- Table tuning advisors: Generated when inefficient queries run against a table. These give aggregated information about the table, the inefficient queries that ran against it, and any existing indexes.
- Index advisors: Identify missing indexes and provide estimates of how much time adding the suggested index could potentially save.
Learn More About Database Performance Analyzer
