View Issue Details

IDProjectCategoryView StatusLast Update
0009432Talerlibeufin-bankpublic2025-05-10 02:11
ReporterAntoine A Assigned ToAntoine A Resolution deadline
ImplementerReviewer 
Release signed byDeployed by 
VerifierCommunicator 
Data protection authority notification requiredNo  
CSIRT notification requiredNo  
Estimated effort (hours)Actual effort (hours)0 
Fast-trackNo
Work packagenone
PrioritynormalSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Product Versiongit (master) 
Target Version1.0Fixed in Version1.0 
Summary0009432: Lazy stats
Descriptionlibeufin-bank has an endpoint for statistics on talerable transactions and cash-in and cash-out amounts. As PostgreSQL is slow to sum the amount of many rows, we create buckets manually. The problem with the current method is that we do this synchronously, this make the transfer transaction write more rows and create contention on the statistics rows, which reduces overall throughput.
By updating the statistics lazily using a worker that only reads the transaction tables and is the only one to write to the statistics table, we could reduce contention and improve the throughput of libeufin-bank transactions.
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Antoine A

2025-01-06 15:54

manager   ~0023940

FIxed using better SQL logic in 4c70adc49dd78381a42608bc1b1d68551f188d5f

Issue History

Date ModifiedUsernameFieldChange
2024-12-30 17:44Antoine ANew Issue
2024-12-30 17:44Antoine AStatusnew => assigned
2024-12-30 17:44Antoine AAssigned To => Antoine A
2025-01-06 15:54Antoine AStatusassigned => informing
2025-01-06 15:54Antoine AResolutionopen => fixed
2025-01-06 15:54Antoine ANote Added: 0023940
2025-01-11 10:11Christian GrothoffProduct Version => git (master)
2025-01-11 10:11Christian GrothoffTarget Version1.0 stretch goals => 1.0
2025-02-14 21:42Christian GrothoffFixed in Version => 1.0
2025-05-10 02:11Christian GrothoffStatusinforming => closed