Select Code to Download

Result:
  System sort: 59 minutes.
  Postgres load (6m) + select (59m): 66 minutes

$ ls -lh dna2.txt 
-rw-rw-r-- 1 xxxxx xxxxx 12G Dec 21 16:38 dna2.txt
...
real    59m12.569s

$ time echo "
       create index dna_test_seq_idx on dna_test (seq)
" | psql -d test
CREATE INDEX
real    63m20.451s

$ time echo "
...
  ->  Seq Scan on dna_test  (cost=0.00..3872406.68 rows=181261568 widt
+h=62) (actual time=17.966..65802.621 rows=181261572 loops=1)
Total runtime: 3463580.243 ms