Postgres Pro
Downloads
Home   >   mailing lists

Re: count(*), EXISTS, indexes - Mailing list pgsql-sql

From Josh Berkus
Subject Re: count(*), EXISTS, indexes
Date
Msg-id 200304111442.48107.josh@agliodbs.com
Whole thread Raw
In response to Re: count(*), EXISTS, indexes  (Itai Zukerman <zukerman@math-hat.com>)
Responses Re: count(*), EXISTS, indexes
List pgsql-sql
Tree view 
Itai,

>   # explain select sum(weight) from rprofile rp where exists (select 1 from
rcount_prof rcp where rcp.profile ~<= rp.profile and ~rcp.psig ~<= rp.psig
and rcp.filter='{734,1944}');

I'm not familiar with the "~" that you have in the query.  What are those for?

Do you have an index on rcp.profile, rcp.psig, rcp.filter?

--
-Josh BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: Itai Zukerman
Date:
Subject: Re: count(*), EXISTS, indexes
Next
From: Itai Zukerman
Date:
Subject: Re: count(*), EXISTS, indexes