Re: [Rdkit-discuss] Postgres indexing question

2018-01-07 Thread Rajarshi Guha
On Sun, Jan 7, 2018 at 9:47 AM, Greg Landrum wrote: > Hi Rajarshi, > > On Sat, Jan 6, 2018 at 6:32 AM, Rajarshi Guha > wrote: > >> Hi, I'm using RDkit 2017.09 with Postgres 9.5. I loaded in ChEMBL23 using >> the instructions given at http://www.rdkit.org/docs/Cartridge.html and >> set up the ind

Re: [Rdkit-discuss] Postgres indexing question

2018-01-07 Thread Greg Landrum
On Sun, Jan 7, 2018 at 3:47 PM, Greg Landrum wrote: > > On Sat, Jan 6, 2018 at 6:32 AM, Rajarshi Guha > wrote: > >> >> Interestingly, what ever query SMILES I put in, the expected row count >> for the Bitmap Index Scan is always 1727. Is this by design? >> > > "by design" makes it sound better t

Re: [Rdkit-discuss] Postgres indexing question

2018-01-07 Thread Greg Landrum
Hi Rajarshi, On Sat, Jan 6, 2018 at 6:32 AM, Rajarshi Guha wrote: > Hi, I'm using RDkit 2017.09 with Postgres 9.5. I loaded in ChEMBL23 using > the instructions given at http://www.rdkit.org/docs/Cartridge.html and > set up the indexes etc. > > However, when I run a substructure query I, EXPLAIN

[Rdkit-discuss] Postgres indexing question

2018-01-05 Thread Rajarshi Guha
Hi, I'm using RDkit 2017.09 with Postgres 9.5. I loaded in ChEMBL23 using the instructions given at http://www.rdkit.org/docs/Cartridge.html and set up the indexes etc. However, when I run a substructure query I, EXPLAIN ANALYZE output looks like chembl_23=> explain analyze select count(*) from r