> -----Original Message----- > From: Thomas Down [mailto:[EMAIL PROTECTED] > Sent: 05 June 2003 10:17 > To: Y D Sun > Cc: [EMAIL PROTECTED] > Subject: Re: [Biojava-l] Different implementation of Sequence? > > Okay, the postgres version of that schema is missing many > "create index" commands (it was autogenerated from the MySQL > schema. MySQL implicitly creates an index for the primary > key of a table, while PostgreSQL does not). > > The most important one is: > > CREATE INDEX sf_pk ON seqfeature (seqfeature_id); > > That should get the system running substantially faster. >
Can I run the command in an existing db? Now I am running it in a db containing 10 sequences, but it is hanging there. George > Also try: > > CREATE INDEX ot_pk ON ontology_term (ontology_term_id); > CREATE INDEX sfs_pk ON seqfeature_source (seqfeature_source_id); > > I'll try and get a better schema file up today. > > Thomas. > _______________________________________________ Biojava-l mailing list - [EMAIL PROTECTED] http://biojava.org/mailman/listinfo/biojava-l
