Re: TEXT column > 1Gb - Mailing list pgsql-general

From Rob Sargent
Subject Re: TEXT column > 1Gb
Date
Msg-id 04ab2b33-be6e-5073-1004-31a7117531af@gmail.com
Whole thread Raw
In response to Re: TEXT column > 1Gb  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: TEXT column > 1Gb
Re: TEXT column > 1Gb
Re: TEXT column > 1Gb
List pgsql-general
On 4/12/23 13:02, Ron wrote:
Must the genome all be in one big file, or can you store them one line per table row?

Not sure what OP is doing with plant genomes (other than some genomics) but the tools all use files and pipeline of sub-tools.  In and out of tuples would be expensive.  Very,very little "editing" done in the usual "update table set val where id" sense.

Lines in a vcf file can have thousands of colums fo nasty, cryptic garbage data that only really makes sense to tools, reader.  Highly denormalized of course.  (Btw, I hate sequencing :) )



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: TEXT column > 1Gb
Next
From: Benedict Holland
Date:
Subject: Re: TEXT column > 1Gb