| |
|
EVENT DETAILS |
|
[Webinar] Indexes are a basic feature of relational databases, & PostgreSQL offers a rich collection of options to developers & designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types & how they apply to different application scenarios. Only then can you make an informed decision about your database index strategy & design. One thing is for sure: not all indexes are appropriate for all circumstances, & using a wrong' index can have the opposite effect to that you intend & problems might only surface once in production. Armed with more advanced knowledge, you can avoid this worst-case scenario! We'll take a look at how to use pg_stat_statment to find opportunities for adding indexes to your database. We'll take a look at when to add an index, & when adding an index is unlikely to result in a good solution. So should you add an index to every column? Come & discover why this strategy is rarely recommended as we take a deep dive into PostgreSQL indexing.
|
|
|
|
|
|
