public inbox for [email protected]
help / color / mirror / Atom feedFrom: Craig James <[email protected]>
To: Jeff Janes <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Can't get two index scans
Date: Thu, 23 Jun 2016 12:52:25 -0700
Message-ID: <CAFwQ8rdkPHJFNOUjELUjSRViDUFFjLYFAPgBizbrh38fk=UY5g@mail.gmail.com> (raw)
In-Reply-To: <CAMkU=1x4KRF0rEs+7C3MkBkeXbEa+TNL05ZCtgCb-=hq5nRTiA@mail.gmail.com>
References: <CAFwQ8reztx+Kw7pGoGTMyD2xt25_Z5Vrt5r4qB3AQ=ybG43QHA@mail.gmail.com>
<CAMkU=1xnuR8wTwMGu9aEnoe54t4C3wk_Bof9P4S=dcJc=0pNtA@mail.gmail.com>
<CAFwQ8rey4+YhU4Jou9ALn-Dz3FU_q4BvHBJxHSeYTU-nGWZLGQ@mail.gmail.com>
<CAMkU=1x4KRF0rEs+7C3MkBkeXbEa+TNL05ZCtgCb-=hq5nRTiA@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
On Thu, Jun 23, 2016 at 8:47 AM, Jeff Janes <[email protected]> wrote:
> On Wed, Jun 22, 2016 at 9:36 PM, Craig James <[email protected]>
> wrote:
> > On Wed, Jun 22, 2016 at 11:36 AM, Jeff Janes <[email protected]>
> wrote:
> ...
> But, JChem's cartridge is apparently not using a GiST index, which is
> what my first guess was. I can't really figure out what PostgreSQL
> API it is tapping into, so whatever it is very well might not support
> multi-column indexes at all.
>
They run a separate chemistry server process, which I believe is a Java
app. My guess (and it's strictly a guess) is that they use classic chemical
bitmap fingerprints, and the index scan runs in their separate process and
only returns the index-scan results.
Craig
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Can't get two index scans
In-Reply-To: <CAFwQ8rdkPHJFNOUjELUjSRViDUFFjLYFAPgBizbrh38fk=UY5g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox