Tune Postgres For Event Queries

Use when an indexer's Postgres event tables get slow past hundreds of millions of rows. Uses BRIN on block_number and targeted indexes so log-range scans stay cheap as the table grows.

jiayaoqijia Updated 81 repo stars

File contents

jiayaoqijia/cryptoskill commit 1359271ee2

Frequently asked questions

npx get-skill add jiayaoqijia/tune-postgres-for-event-queries