From: Marcus Eggenberger <egs@quassel-irc.org>
Date: Fri, 26 Jun 2009 08:31:33 +0000 (+0200)
Subject: Helping Postgres' Query Planer.
X-Git-Tag: 0.5-rc1~174
X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=commitdiff_plain;h=4bb04fc5758f566e58d560d6f8c510c5cb038486;ds=sidebyside

Helping Postgres' Query Planer.
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.
---

diff --git a/src/core/SQL/PostgreSQL/14/select_messages.sql b/src/core/SQL/PostgreSQL/14/select_messages.sql
index eae93cf6..1bd2683f 100644
--- a/src/core/SQL/PostgreSQL/14/select_messages.sql
+++ b/src/core/SQL/PostgreSQL/14/select_messages.sql
@@ -1,6 +1,6 @@
 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
diff --git a/src/core/SQL/PostgreSQL/14/select_messagesNewerThan.sql b/src/core/SQL/PostgreSQL/14/select_messagesNewerThan.sql
index 7dda1891..393d3cfa 100644
--- a/src/core/SQL/PostgreSQL/14/select_messagesNewerThan.sql
+++ b/src/core/SQL/PostgreSQL/14/select_messagesNewerThan.sql
@@ -1,6 +1,6 @@
 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
diff --git a/src/core/SQL/PostgreSQL/14/select_messagesRange.sql b/src/core/SQL/PostgreSQL/14/select_messagesRange.sql
index e7a6a5a6..9bd86134 100644
--- a/src/core/SQL/PostgreSQL/14/select_messagesRange.sql
+++ b/src/core/SQL/PostgreSQL/14/select_messagesRange.sql
@@ -1,6 +1,6 @@
 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