Re: 8K Limit, whats the best strategy?

Поиск
Список
Период
Сортировка
От Thomas Swan
Тема Re: 8K Limit, whats the best strategy?
Дата
Msg-id 5.0.0.11.2.20000815103331.01f24460@sunset.backbone.olemiss.edu
обсуждение исходный текст
Ответ на 8K Limit, whats the best strategy?  (Keith Wong <keith@e-magine.com.au>)
Список pgsql-sql
At 06:29 AM 8/15/2000, Keith Wong wrote:<br /><blockquote cite="cite" type="cite">Hi everyone,<br /><br /> Just
wonderingwhat strategies people have used to get around the 8K row limit in Postgres.<br /> If anyone has been troubled
bythis limitation before and has a nice solution around it, I would love to hear it.<br /><br /> My application is a
web-basedsystem in which needs to store large amounts of text.<br /> The text stored needs to searchable as
well.</blockquote><br/>  You can you the type LZTEXT which is compressed text so your mileage will vary.<br /><br />
Theother option is to go in and recompile for a larger row size.  Most of the people I have talked to had no problems
withthis route.  I move the size limit on an x86 Linux box to 32K (the max) and have not had any problems.   In the
nextrelease, I don't believe the row size limit will exist (correct me if I'm wrong). <br /><br /> Let me know the
systemyour on, and I will try to help if I can.<br /><br /> - <br /> - <b><u>Thomas Swan</u></b>
                                  <br/> - Graduate Student  - Computer Science<br /> - The University of Mississippi<br
/>- <br /> - "People can be categorized into two fundamental <br /> - groups, those that divide people into two groups
<br/> - and those that don't." 

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

Предыдущее
От: "Branden R. Williams"
Дата:
Сообщение: ERROR: unexpected SELECT query in exec_stmt_execsql()
Следующее
От: "Adam Lang"
Дата:
Сообщение: Re: 8K Limit, whats the best strategy?