Miscellany

issuemaps_c=# \d crawled_urls
                                         Table "public.crawled_urls"
         Column          |       Type        |                           Modifiers                           
-------------------------+-------------------+---------------------------------------------------------------
 url_id                  | integer           | not null default nextval(('crawled_url_seq'::text)::regclass)
 source_host             | character varying | 
 source_url              | character varying | 
 target_host             | character varying | 
 target_url              | character varying | 
 display_source_url      | character varying | 
 display_target_url      | character varying | 
 startingpoint_privilege | integer           | 
 crawled_date            | character varying | 
Indexes:
    "crawled_urls_pkey" PRIMARY KEY, btree (url_id)
    "crawled_urls_target_url" btree (target_url)
    "target_host" btree (md5(target_host::text))
    "target_url" btree (md5(target_url::text))



issuemaps_c=# explain Update crawled_urls set startingpoint_privilege = 1 where target_host='google.com';
                              QUERY PLAN                              
----------------------------------------------------------------------
 Seq Scan on crawled_urls  (cost=0.00..138868.11 rows=9674 width=234)
   Filter: ((target_host)::text = 'google.com'::text)
(2 rows)


issuemaps_c=# explain Update crawled_urls set startingpoint_privilege = 1 where md5(target_host)=md5('google.com');
                                        QUERY PLAN                                         
-------------------------------------------------------------------------------------------
 Bitmap Heap Scan on crawled_urls  (cost=492.08..29855.50 rows=9677 width=234)
   Recheck Cond: (md5((target_host)::text) = '1d5920f4b44b27a802bd77c4f0536f5a'::text)
   ->  Bitmap Index Scan on target_host  (cost=0.00..489.66 rows=9677 width=0)
         Index Cond: (md5((target_host)::text) = '1d5920f4b44b27a802bd77c4f0536f5a'::text)
(4 rows)