indexer icon indicating copy to clipboard operation
indexer copied to clipboard

Reserve DB Connection Handles for Block Import

Open winder opened this issue 3 years ago • 0 comments

Problem

It is currently possible for queries to compete with the block import process. If queries exhaust the database connections it can cause the import process to fall behind.

Solution

Reserve DB connections for the import process.

Tolik has told me that block import currently requires two connections. This would require some amount of refactoring in the way we use pgx.

Dependencies

Configurable connection pool size: #826

Urgency

winder avatar Jan 18 '22 22:01 winder