table design question

Поиск
Список
Период
Сортировка
Искать
От
George Johnson
Тема
table design question
Дата
Msg-id
NEBBJGKMGLGMDGBMOHJNOEFFCAAA.gjohnson@jdsc.com
Список
Дерево обсуждения
table design question "George Johnson" <gjohnson@jdsc.com>
Hello All,

I need some advice regarding table column types and read speeds.
I have a database of protein sequence data (strings of characters mostly
including 20 alphabet characters) and nucleotide base sequence
data (strings of characters mostly including a,t,g,c).

When I wrote the homegrown backend to our database way back when, I cooked
up some fun ways of storing the data for very fast access speeds (not really
interested in doing SQL-ish searching on the columns in place).

I'm wondering what the best choice of storage is:  just leave them as text
strings, do some fancy hexidecimal conversion, etc?  Or does it matter?  The
tables for the most part contain the sequence information as well as a
primary key.

Any thoughts/suggestions would be useful.

Happy Holidays (oh ... darn ... it's going to be 60's and sunny AGAIN on the
peninsula today [nudge to back-east bretheren] heheh)

George Johnson

В списке pgsql-general по дате отправления
От: Ned Lilly
Дата:
Сообщение: Re: Postgres demographics?
От: Martin A. Marques
Дата:
Сообщение: Re: logs
FAQ