<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-CA link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi Scott/GMOD Help Desk<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We are using 'bp_seqfeature_load.pl' to load a Postgresql DB::SeqFeature::Store database. Upon load of a SNP.gff file, we found the task took about 1.5 weeks to complete. Thus we have researched whether there exists a fast loader for Postgresql; we are aware that there are fast and bulk loaders for MySQL.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Our search (GMOD site, mailing lists, general Google search, etc.) yielded no information on an existing fast/bulk loader for Postgresql, which led us to send this email.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>It seems we have two options available to us to increase the speed of load: 1) move to a MySQL platform for our GBrowse database; 2) split large files to be loaded into smaller bits and load as such.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Option 1 is not one we prefer. We have other Postgresql databases that interact with the GBrowse database, which we do not want to move to the MySQL platform. Also, we would prefer not to have two different database platforms (i.e. MySQL and Postgresql) serving the web site that features GBrowse because we have a query feature on the web site that interacts with GBrowse, both of which we would like to be served by a Postgresql database.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Our question: has anyone written a fast or bulk loader for Posgresql? If so, could you point us in that direction? If not, do you have any other suggestions we may not have presented above?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Please advise. Thank you for your time.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Margie Manker<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-CA'>Project Analyst<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-CA'>The Centre for Applied Genomics<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-CA'>The Hospital for Sick Children<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-CA'><a href="mailto:manker@populargenetics.ca">manker@populargenetics.ca</a> <o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>