-rw-rw-r-- 1 aardvark aardvark 1.2G Dec 11 15:13 junk.dat

grep -c '^>' junk.dat 
10000000

#  one-off: create database table 'junk':

time < junk.dat psql -c "drop table if exists junk;
  create table junk(accession text, sequence text);
  copy junk from stdin csv delimiter E'\t';" ;

real    1m35.215s

# one-off: create index on database table 'junk':

time echo "
  create index junk_idx on junk (accession);
  analyze junk;" | psql

real    7m58.633s


##</code><code>##


       name protein (or dna?)             retrieval time

>ewwhsefmyqqadboyjannenpqvtntiqjjheuwdvuh Time: 160.624 ms
>braniambsateowfjdmbgsmflbsosllhzureeponx Time: 124.207 ms
>aulshznwumwcbqcgamrgpgysmkbkykjmdypqgglc Time: 46.639 ms
>sadwirrivjzbezsrgcxpeavketadfvszwamxzwer Time: 74.509 ms
>pqrjkynzzeromipzagvunnudrygxbdvokghnkmes Time: 83.611 ms
>mfjqtvvvoibwubqyrshwtybpdyexxsrsyndyjbgc Time: 69.637 ms
>dwiepreektknecinzqzbyjwsxcjblszxqhflhivd Time: 37.553 ms
>ifuwdcrwwofedjeehdheryzcabhkpfnbnfqcddkk Time: 94.236 ms
>thfhatnyothgvtmwwdsflyukanykawezrlvnkgyy Time: 56.977 ms
>qspsniccydlcrbcinkmbtoryktkuysvhkpziamnu Time: 50.896 ms

>ewwhsefmyqqadboyjannenpqvtntiqjjheuwdvuh Time: 3.799 ms
>braniambsateowfjdmbgsmflbsosllhzureeponx Time: 2.029 ms
>aulshznwumwcbqcgamrgpgysmkbkykjmdypqgglc Time: 1.943 ms
>sadwirrivjzbezsrgcxpeavketadfvszwamxzwer Time: 1.883 ms
>pqrjkynzzeromipzagvunnudrygxbdvokghnkmes Time: 2.046 ms
>mfjqtvvvoibwubqyrshwtybpdyexxsrsyndyjbgc Time: 2.529 ms
>dwiepreektknecinzqzbyjwsxcjblszxqhflhivd Time: 1.863 ms
>ifuwdcrwwofedjeehdheryzcabhkpfnbnfqcddkk Time: 1.952 ms
>thfhatnyothgvtmwwdsflyukanykawezrlvnkgyy Time: 2.042 ms
>qspsniccydlcrbcinkmbtoryktkuysvhkpziamnu Time: 2.011 ms

>ewwhsefmyqqadboyjannenpqvtntiqjjheuwdvuh Time: 2.632 ms
>braniambsateowfjdmbgsmflbsosllhzureeponx Time: 1.992 ms
>aulshznwumwcbqcgamrgpgysmkbkykjmdypqgglc Time: 1.889 ms
>sadwirrivjzbezsrgcxpeavketadfvszwamxzwer Time: 5.196 ms
>pqrjkynzzeromipzagvunnudrygxbdvokghnkmes Time: 2.091 ms
>mfjqtvvvoibwubqyrshwtybpdyexxsrsyndyjbgc Time: 2.177 ms
>dwiepreektknecinzqzbyjwsxcjblszxqhflhivd Time: 1.877 ms
>ifuwdcrwwofedjeehdheryzcabhkpfnbnfqcddkk Time: 2.092 ms
>thfhatnyothgvtmwwdsflyukanykawezrlvnkgyy Time: 12.836 ms
>qspsniccydlcrbcinkmbtoryktkuysvhkpziamnu Time: 1.867 ms

>ewwhsefmyqqadboyjannenpqvtntiqjjheuwdvuh Time: 1.965 ms
>braniambsateowfjdmbgsmflbsosllhzureeponx Time: 1.929 ms
>aulshznwumwcbqcgamrgpgysmkbkykjmdypqgglc Time: 1.857 ms
>sadwirrivjzbezsrgcxpeavketadfvszwamxzwer Time: 1.999 ms
>pqrjkynzzeromipzagvunnudrygxbdvokghnkmes Time: 2.009 ms
>mfjqtvvvoibwubqyrshwtybpdyexxsrsyndyjbgc Time: 1.981 ms
>dwiepreektknecinzqzbyjwsxcjblszxqhflhivd Time: 1.865 ms
>ifuwdcrwwofedjeehdheryzcabhkpfnbnfqcddkk Time: 1.880 ms
>thfhatnyothgvtmwwdsflyukanykawezrlvnkgyy Time: 1.878 ms
>qspsniccydlcrbcinkmbtoryktkuysvhkpziamnu Time: 2.158 ms