TEXT question... Was 7.0 key features

Поиск
Список
Период
Сортировка
От Mitch Vincent
Тема TEXT question... Was 7.0 key features
Дата
Msg-id 039301bfb92f$298d70c0$4100000a@venux.net
обсуждение исходный текст
Ответ на Re: Re: It happened again: Server hung up solid  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
This brings me to another question. Hopefully there isn't a 8k (max 32k)
limit on TEXT fields -- I'll assume there isn't a limit on TEXT fields for
the purpose of this email..

What do you guys think of storing whole text files (normally stored in a
flat file) in the database for searching purposes? Would a search on an
indexed TEXT field be slow as mud?

I'll try it on my home machine for kicks, just wanted to get some
theoretical opinions...

Thanks!

- Mitch

"The only real failure is quitting."

> > Is the row length limit 8k? If not, what is the row length limit?
>
> 8k by default, max is 32K if you recompile-




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: 7.0 key features
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: 7.0 key features