> On Apr 12, 2023, at 7:59 AM, Joe Carlson <jwcarl...@lbl.gov> wrote:
>
> The use case is genomics. Extracting substrings is common. So going to
> chunked storage makes sense.
Are you storing nucleotide sequences as text strings? If using the simple
4-character (A,C,G,T) alphabet, you can store four bases per byte. If using a
nucleotide code 16-character alphabet you can still get two bases per byte. An
amino acid 20-character alphabet can be stored 8 bases per 5 bytes, and so
forth. Such a representation might allow you to store sequences two or four
times longer than the limit you currently hit, but then you are still at an
impasse. Would a factor or 2x or 4x be enough for your needs?
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
