That did it! I certainly should have been able to figure that out on my
own. Thanks for the help!
Unfortunately, I'm still looking at rather slow queries across my entire
dataset. I might wind up having to find another solution.
Gideon.
On Wed, Aug 12, 2015 at 6:29 PM Tom Lane wrote:
>
rying to run is:
EXPLAIN SELECT * FROM vcf
WHERE EXISTS (SELECT region FROM qcregions
WHERE qcregions.chr = vcf.chr
AND qcregions.type = 'include'
AND vcf.pos <@ qcregions.region);
Let me know what else I can try,
Gideon.
On Wed, Aug 12, 2015 at 11:07 AM Gideon Dr
ed by gcc (GCC) 5.1.0,
64-bit
(1 row)
Thanks for the help,
Gideon.
On Tue, Aug 11, 2015 at 10:23 PM Tom Lane wrote:
> Gideon Dresdner writes:
> > I had a discussion on IRC today with RhodiumToad regarding optimizing a
> > specific query. We didn't manage to figure out how t
Greetings,
I had a discussion on IRC today with RhodiumToad regarding optimizing a
specific query. We didn't manage to figure out how to get postgres to hit a
GIST index.
The bigger picture is that I am trying to do some bioinformatics and
thought that postgres would be a great way of getting the
