stacks-blockchain-api icon indicating copy to clipboard operation
stacks-blockchain-api copied to clipboard

Fix/event replay perf

Open zone117x opened this issue 2 years ago • 3 comments

Removes the temporary pg table used during event-replay. This was originally in place to handle tsv files that contains 1) duplicate events, and 2) out of order events.

Now that we no longer support live appending to tsv files (only direct exports), we should no longer be dealing with these types of "dirty" tsv files.

This should be a performance improvement now that postgres no longer has to serve reads from the temp table while also writing events during ingestion.

zone117x avatar Mar 03 '23 19:03 zone117x

🚀 Deployed on https://deploy-preview-1572--stacks-blockchain-api.netlify.app

github-actions[bot] avatar Mar 03 '23 19:03 github-actions[bot]

Coverage Status

Coverage: 78.18% (+1.09%) from 77.086% when pulling a594ffca589f5588793be3dede047734422254a4 on fix/event-replay-perf into e2b58b2208e6a06a498472599159235ebb821a08 on master.

coveralls avatar Mar 03 '23 19:03 coveralls

This will likely be built upon later on when we tackle event-replay perf. Leaving this PR open as draft for now.

zone117x avatar Apr 20 '23 12:04 zone117x