~/talk

Data Driven Cache Invalidation

Talkat EuroPython 2011 · 2011-06-20..06-26· [python, web-performance]
slides:none on file

Shows how to invalidate HTTP caches from the database by sending Varnish purge requests from Postgres. Uses triggers + PL/Python for a simple synchronous purge (blocking, brittle across multiple writers), then replaces it with an async pipeline: insert events into pgq (SkyTools), run a consumer that calls Varnish admin to purge URLs, and optionally tag cached responses with custom headers. Explains tradeoffs, performance, retry behavior and when per-URL vs broader purges make sense.

AI-written summary · about

  1. 0:00Introduction and architecture
  2. 4:16Application demo setup
  3. 10:48Adding varnish and caching
  4. 16:32Data-driven invalidation
  5. 20:55Trigger-based purging
  6. 28:13Asynchronous queueing with PGQ
  7. 42:54Advanced strategies and Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.