Re: 8K Limit, whats the best strategy?

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."