Hi Greg,
Gesendet: Freitag, 15. Juni 2018 um 15:27 Uhr
Von: "Greg Landrum" <[email protected]>
An: "Sebastian Wandernoth" <[email protected]>
Cc: "RDKit Discuss" <[email protected]>
Betreff: Re: [Rdkit-discuss] creating an index on reactions in postgres
Von: "Greg Landrum" <[email protected]>
An: "Sebastian Wandernoth" <[email protected]>
Cc: "RDKit Discuss" <[email protected]>
Betreff: Re: [Rdkit-discuss] creating an index on reactions in postgres
Hi Sebastian,
On Fri, Jun 15, 2018 at 12:38 PM Sebastian Wandernoth <[email protected]> wrote:
I managed to create the index and the search is much faster now.
I'm glad you figured that out. I'm sure Nadine (who was going to otherwise need to answer) is too! :-)
Would you mind sharing the command that you used?
In the end I simply used
"create index rxn_idx on chemical.reactions_fromrxn using gist(rdkit_reactions);"
with chemical.reactions_fromrxn being the name of the table and rdkit_reactions the name of the column.
I must've simply had a typo in it before.
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________ Rdkit-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
