Home > PostgresConf Silicon Valley

PostgresConf Silicon Valley

Did you miss us at PostgresConf Silicon Valley in San Jose? Have no fear! Here's a sneak peek video of Baron Schwartz delivering his talk on database indexing: How to Index Your Database Indexing is Simple, Approachable, and Useful Do you know what database indexes are and how they work? Do they seem hard to understand? They don't have to be. The basic principles you need to know are simple and easy to remember. And developers need to know the basics of indexing: your DBAs can't save you, because discovering you need an index after you deploy a feature is often too little, too late. This talk will give you the fundamentals without theory or lecturing. You’ll learn the three purposes of an index, the three characteristics of how a query plan uses indexes, and how to design indexes that are most likely to be optimal for general-purpose querying, whether or not you know all the queries and shape of the data.

 
SolarWinds
SolarWinds
We’re Geekbuilt.® Developed by network and systems engineers who know what it takes to manage today's dynamic IT environments, SolarWinds has a deep connection to…
Read more

Tweets

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Head Geek @ChrystalT87 explains how critical #digitaltransformation is to succeed in an uncertain economy. t.co/8i3PQ6noeJ

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Streaming now: An update on the SolarWinds investigation from CEO Sudhakar Ramakrishna, former CISA head and KSG Fo… t.co/HPG3gIsbK5

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Upgrades can be a major pain. But the benefits often exceed the effort. Listen to the experts cover the pros to upg… t.co/lz5OTUgAkS