Note: this does not guarantee, that issues with Postgres are resolved
for everyone. These changes produced very good results in a couple of
test series. Let me know how they work out for you.
SELECT messageid, time, type, flags, sender, message
FROM backlog
-JOIN sender ON backlog.senderid = sender.senderid
+LEFT JOIN sender ON backlog.senderid = sender.senderid
WHERE bufferid = $1
ORDER BY messageid DESC
LIMIT $2
\ No newline at end of file
SELECT messageid, time, type, flags, sender, message
FROM backlog
-JOIN sender ON backlog.senderid = sender.senderid
+LEFT JOIN sender ON backlog.senderid = sender.senderid
WHERE backlog.messageid >= $1 AND bufferid = $2
ORDER BY messageid DESC
LIMIT $3
\ No newline at end of file
SELECT messageid, time, type, flags, sender, message
FROM backlog
-JOIN sender ON backlog.senderid = sender.senderid
+LEFT JOIN sender ON backlog.senderid = sender.senderid
WHERE backlog.messageid >= $1
AND backlog.messageid < $2
AND bufferid = $3