Dave on Nostr: npub1jtm4d…rrxtn The issue comes down to deadlocks on the episodes table. If we ...
npub1jtm4dxvu3ccgk60wvvt0uw9j9vz7nuc80f7agrv0vgkkushxk5zq0rrxtn (npub1jtm…rxtn) The issue comes down to deadlocks on the episodes table. If we delete episodes that have rolled off with every scan it’s too many DELETE’s and the table locks causing all the aggregators to freeze until that one feed is processed. It might work better now with the new database server. I just haven’t gotten to trying it yet.
Published at
2023-07-17 11:10:36Event JSON
{
"id": "7403eced52987d62d1aba7522c4bc652c042a88207fcc68acdfb53b357cbbfc6",
"pubkey": "01b564093b88a80fa5269f27044e1dea1d832f56f9b40f2064a6ba39506f27e2",
"created_at": 1689592236,
"kind": 1,
"tags": [
[
"p",
"92f756999c8e308b69ee6316fe38b22b05e9f3077a7dd40d8f622d6e42e6b504",
"wss://relay.mostr.pub"
],
[
"p",
"452fa1bb618154a61b5b88d325446577ed6095a21bb29e1049b4acb04d2e61bb",
"wss://relay.mostr.pub"
],
[
"e",
"f384ad832269f6f2f0db3f6d2dde47dcacc7fcda3d65785f67fb991e7fed88b9",
"wss://relay.mostr.pub",
"reply"
],
[
"mostr",
"https://podcastindex.social/users/dave/statuses/110729116790888053"
]
],
"content": "nostr:npub1jtm4dxvu3ccgk60wvvt0uw9j9vz7nuc80f7agrv0vgkkushxk5zq0rrxtn The issue comes down to deadlocks on the episodes table. If we delete episodes that have rolled off with every scan it’s too many DELETE’s and the table locks causing all the aggregators to freeze until that one feed is processed. It might work better now with the new database server. I just haven’t gotten to trying it yet.",
"sig": "bdb759a245a433a1f067a7090855df6e2bb438effa6457a7c07f8e1210cccc2ca9862799068bafe67924848c10e77b269f8bf6433bf60420ce57308d5a9d8d5a"
}
