mario@hub.somaton.com

After some testing i reverted this commit in favour of an easier fix:
https://framagit.org/hubzilla/core/-/commit/8576c333fba1c789a1b9a7d7461cbee143730357

That will hopefully resolve the issue with GTS :crossed_fingers:

@Max Kostikov ah... that is somehow suprising...

Anyway, i think i will go with

ALTER TABLE workerq
    ADD INDEX idx_claim (
        workerq_reservationid,
        workerq_priority DESC,
        workerq_id ASC
    );

as you suggested first.

@Max Kostikov do you mean without workerq_id or without workerq_reservationid?

@Max Kostikov can't compete with your numbers :rolling_on_the_floor_laughing:

@Max Kostikov that would be great!

@Max Kostikov have you tried index with workerq_priority and workerq_id only? All rows (except max worker count) will have workerq_reservationid NULL :thinking_face:

@Max Kostikov 6M is a lot :astonished_face:
Mostly convo right?

@Max Kostikov which query is it that took so long?

Took some time to build php-8.5.12 on my arm board but it looks like it worked. The archlinuxarm repo is usually way behind so i decided to build from source this time.

Mastodon API :elephant:

@Alfred Bühler do you still see this?
I have spent some time looking at this but could not see anything wrong in the code. It would be great if you could share a complete log of posting/sending a post.

@mrjive

I've discovered that auto completion is case sensitive

Yes, postgresql searches are CS by default not CS.
hub.hubzilla.de uses postgres :slightly_smiling_face: