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
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
WHERE bufferid = $1
ORDER BY messageid DESC
LIMIT $2
\ No newline at end of file
SELECT messageid, time, type, flags, sender, message
FROM backlog
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
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
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
WHERE backlog.messageid >= $1
AND backlog.messageid < $2
AND bufferid = $3