title: Increase query speed in PostgreSQL
body: <p>I am experiencing slow query times on my database (all tested locally so far) and not sure how to go about it. The database itself has 44 tables and some of these tables have over 1 million records (mainly the movies, actresses and actors tables). </p>
  
  <p>The table is made via JMDB using the flat files on IMDB. Also the SQL query that I am about to show is from that said program (that too experiences very slow search times). I have tried to include as much information as I can, such as the query plan etc.</p>
  
  <pre><code>"QUERY PLAN"&lt;br /&gt; 
  "HashAggregate  (cost=46492.52..46493.50 rows=98 width=46)"&lt;br /&gt;
  "  Output: public.movies.title, public.movies.movieid, public.movies.year"&lt;br /&gt;
  "  -&gt;  Append  (cost=39094.17..46491.79 rows=98 width=46)"&lt;br /&gt;
  "        -&gt;  HashAggregate  (cost=39094.17..39094.87 rows=70 width=46)"&lt;br /&gt;
  "              Output: public.movies.title, public.movies.movieid, public.movies.year"&lt;br /&gt;
  "              -&gt;  Seq Scan on movies  (cost=0.00..39093.65 rows=70 width=46)"&lt;br /&gt;
  "                    Output: public.movies.title, public.movies.movieid, public.movies.year"&lt;br /&gt;
  "                    Filter: (((title)::text ~~* '%Babe%'::text) AND ((title)::text !~~* '""%}'::text))"&lt;br /&gt;
  "        -&gt;  Nested Loop  (cost=0.00..7395.94 rows=28 width=46)"&lt;br /&gt;
  "              Output: public.movies.title, public.movies.movieid, public.movies.year"&lt;br /&gt;
  "              -&gt;  Seq Scan on akatitles  (cost=0.00..7159.24 rows=28 width=4)"&lt;br /&gt;
  "                    Output: akatitles.movieid, akatitles.language, akatitles.title, &lt;akatitles.addition"&lt;br /&gt;
  "                    Filter: (((title)::text ~~* '%Babe%'::text) AND ((title)::text !~~* '""%}'::text))"&lt;br /&gt;
  "              -&gt;  Index Scan using movies_pkey on movies  (cost=0.00..8.44 rows=1 width=46)"&lt;br /&gt;
  "                    Output: public.movies.movieid, public.movies.title, public.movies.year, public.movies.imdbid"
  "                    Index Cond: (public.movies.movieid = akatitles.movieid)"&lt;br /&gt;
  </code></pre>
  
  <hr>
  
  <pre><code>SELECT * FROM (
      (SELECT DISTINCT title, movieid, year 
      FROM movies 
      WHERE title ILIKE '%Babe%' AND NOT (title ILIKE '"%}'))
  UNION
      (SELECT movies.title, movies.movieid, movies.year 
      FROM movies 
      INNER JOIN akatitles ON movies.movieid=akatitles.movieid 
      WHERE akatitles.title ILIKE '%Babe%' AND NOT (akatitles.title ILIKE '"%}'))
  ) AS union_tmp2;
  </code></pre>
  
  <hr>
  
  <pre><code>Returns 612 Rows in 9078ms&lt;br /&gt;
  Database backup (plain text) is 1.61GB
  </code></pre>
  
  <p>It's a really complex query and I am not fully cognizant on it, like I said it was spat out by JMDB. </p>
  
  <p>Do you have any suggestions on how I can increase the speed ?</p>