InfoTechTarget and Informa Tech's Digital Businesses Combine.

Together, we power an unparalleled network of 220+ online properties covering 10,000+ granular topics, serving an audience of 50+ million professionals with original, objective content from trusted sources. We help you gain critical insights and make more informed decisions across your business priorities.

Turn the Tables on Poor Database Performance

Presented by

Kevin Kline, SolarWinds Technical Evangelist and Kellyn Gorman, Director of Data and AI at Silk

About this talk

It’s rare to find a database completely free from the ills of poor design and/or inefficient queries. The result? Typically, higher I/O, longer user wait times, greater amounts of blocking, and increased resource consumption and contention.   So, what’s the best way to tackle the issues and maximize return on time invested? Tune the SQL statements? Add another index? Add more columns to an existing index?   Join database experts Kevin Kline, technical evangelist for database technology at SolarWinds, and Kellyn Gorman, director of data and AI at Silk, for a discussion about optimizing PostgreSQL database performance. Kevin and Kellyn will cover a variety of critical insights into query efficiency and table indexing on PostgreSQL, such as:  *Assess query inefficiencies by reading execution plans.  *Review table and index design for optimal performance.  *Determine the priority of what options to tune first by reviewing overall workload behavior.  Finally, Kevin will demonstrate the newest features in Database Performance Analyzer (DPA) that make the entire performance tuning process faster and easier!
SolarWinds

SolarWinds

14631 subscribers114 talks
SolarWinds: Simple. Powerful. Secure IT.
Our Easy-to-Use Products Scale with You as You Grow to Meet the Ever-Changing Needs of IT. We Design Products To Empower Technology Professionals To Do Their Jobs More Effectively.
Related topics