View Issue Details

IDProjectCategoryView StatusLast Update
0009432Talerlibeufin-bankpublic2025-01-06 16:54
ReporterAntoine A Assigned ToAntoine A  
PrioritynormalSeverityfeatureReproducibilityN/A
Status resolvedResolutionfixed 
Target Version1.0 stretch goals 
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.

Activities

Antoine A

2025-01-06 16:54

developer   ~0023940

FIxed using better SQL logic in 4c70adc49dd78381a42608bc1b1d68551f188d5f

Issue History

Date Modified Username Field Change
2024-12-30 18:44 Antoine A New Issue
2024-12-30 18:44 Antoine A Status new => assigned
2024-12-30 18:44 Antoine A Assigned To => Antoine A
2025-01-06 16:54 Antoine A Status assigned => resolved
2025-01-06 16:54 Antoine A Resolution open => fixed
2025-01-06 16:54 Antoine A Note Added: 0023940