BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//pretalx.coscup.org//coscup-2026//talk//XLKBSU
BEGIN:VTIMEZONE
TZID:CST
BEGIN:STANDARD
DTSTART:20000101T000000
RRULE:FREQ=YEARLY;BYMONTH=1
TZNAME:CST
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-coscup-2026-XLKBSU@pretalx.coscup.org
DTSTART;TZID=CST:20260809T104500
DTEND;TZID=CST:20260809T111500
DESCRIPTION:Covering indexes\, partial indexes\, access methods\, operator 
 classes\, Index-only scans... Indexes in PostgreSQL are extensible and hav
 e a lot of features\, so it's not always easy to know how to best use them
  or when not to use them.\n\nIn this talk we will cover multiple areas of 
 indexing\, giving example scenario example and best practice to highlight 
 their use cases\, and general improvements around indexes in the recent re
 leases.\n\nWe will also cover some extensions around indexing\, including 
 hypopg that allows you to create hypothetical indexes to help you decide w
 hether an index should be created or not\, and other external tools to det
 ect various problems around indexes.
DTSTAMP:20260713T142501Z
LOCATION:RB101
SUMMARY:Index best practice and hypothetical indexes in PostgreSQL - Julien
  Rouhaud
URL:https://pretalx.coscup.org/coscup-2026/talk/XLKBSU/
END:VEVENT
END:VCALENDAR