SQL: Improved performance of update_vnpopularity()

The previous statement was optimized for PostgreSQL 8.3 and took only about a
second, but after the update to 8.4 it took about 10 times longer due to a
different execution plan being generated. This slightly reworded statement
generates a more efficient plan on 8.4.

2 files changed, 2 insertions, 2 deletions

diff --git a/util/dump.sql b/util/dump.sql
index a5451395..e0af79e8 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -481,7 +481,7 @@ BEGIN
       SELECT v.uid, v.vid, sqrt(count(*))::real
         FROM votes v
         JOIN votes v2 ON v.uid = v2.uid AND v2.vote < v.vote
-        WHERE v.uid NOT IN(SELECT id FROM users WHERE ign_votes)
+        JOIN users u ON u.id = v.uid AND NOT ign_votes
     GROUP BY v.vid, v.uid;
   CREATE OR REPLACE TEMP VIEW tmp_pop2 (vid, win) AS
     SELECT vid, sum(rank) FROM tmp_pop1 GROUP BY vid;
diff --git a/util/updates/update_2.9.sql b/util/updates/update_2.9.sql
index d11a5eed..3b3e147d 100644
--- a/util/updates/update_2.9.sql
+++ b/util/updates/update_2.9.sql
@@ -64,7 +64,7 @@ BEGIN
       SELECT v.uid, v.vid, sqrt(count(*))::real
         FROM votes v
         JOIN votes v2 ON v.uid = v2.uid AND v2.vote < v.vote
-        WHERE v.uid NOT IN(SELECT id FROM users WHERE ign_votes)
+        JOIN users u ON u.id = v.uid AND NOT ign_votes
     GROUP BY v.vid, v.uid;
   CREATE OR REPLACE TEMP VIEW tmp_pop2 (vid, win) AS
     SELECT vid, sum(rank) FROM tmp_pop1 GROUP BY vid;