Hi everyone,
Just wondering what strategies people have used to get around the 8K row limit in Postgres.
If anyone has been troubled by this limitation before and has a nice solution around it, I would love to hear it.
My application is a web-based system in which needs to store large amounts of text.
The text stored needs to searchable as well.
The other option is to go in and recompile for a larger row size. Most of the people I have talked to had no problems with this route. I move the size limit on an x86 Linux box to 32K (the max) and have not had any problems. In the next release, I don't believe the row size limit will exist (correct me if I'm wrong).
Let me know the system your on, and I will try to help if I can.
-
- Thomas Swan
- Graduate Student - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."
