tk,
@tk@bbs.kawa-kun.com avatar

@feld @lanodan Is there any way to switch to a different message broker than the one that's backed by Postgres? I'm wondering if the I/O issue that @sun and I ran into might be exacerbated by a DB-backed queue.

feld,
@feld@bikeshed.party avatar

@tk @lanodan @sun I personally think it's bad queue design and I'm working on a branch to remediate that. Too many queues, some most expensive operations (DELETE) allowed too many concurrently.

tk,
@tk@bbs.kawa-kun.com avatar

@feld @lanodan @sun Deletes are the devil's work. :blobfox0_0:

tk,
@tk@bbs.kawa-kun.com avatar

@feld @lanodan @sun I wonder if the auto-vacuum could be involved here, too. A lot of deletes would require the auto-vacuum to do a lot of I/O work. :blobfoxthink:

icedquinn,
@icedquinn@blob.cat avatar

@tk @feld @lanodan @sun why vacuum though? the db will reuse that space

lanodan,
@lanodan@queer.hacktivis.me avatar

@icedquinn @tk @feld @sun auto is an important keyword here ^^

tk,
@tk@bbs.kawa-kun.com avatar

@icedquinn @feld @lanodan @sun All I know is that when I got Postgres back up after migrating to the new volume, the vacuum worker was doing a ton of I/O.

sun,
@sun@shitposter.world avatar

@tk @feld @lanodan its not switchable but it's probably not the performance cause.

tk,
@tk@bbs.kawa-kun.com avatar

@sun @feld @lanodan I wonder if there's a way to do I/O analysis beyond slow query logs.

feld,
@feld@bikeshed.party avatar

@tk @sun @lanodan I'd love to see it personally if you want to offer me a shell and if I could tinker with the branch being used

tk,
@tk@bbs.kawa-kun.com avatar

@feld @lanodan @sun No thanks, Jia. :blobfoxwinkmlem:

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • DreamBathrooms
  • ngwrru68w68
  • modclub
  • magazineikmin
  • thenastyranch
  • rosin
  • khanakhh
  • InstantRegret
  • Youngstown
  • slotface
  • Durango
  • kavyap
  • mdbf
  • GTA5RPClips
  • JUstTest
  • ethstaker
  • normalnudes
  • tester
  • osvaldo12
  • everett
  • cubers
  • tacticalgear
  • anitta
  • Leos
  • provamag3
  • cisconetworking
  • megavids
  • lostlight
  • All magazines