James Cloos <[EMAIL PROTECTED]> writes: > I'm designing a schema for an app that requires two large blobs per > row. Given that querying does not hit those, I presume it is > beneficial to move the blobs out of the main table.
You shouldn't contort your schema artificially in order to do that. Postgres automatically stores wide fields out-of-line, so if "large" means "more than a couple KB after compression" then the system will do this behind the scenes and there's no need for you to do it. See http://developer.postgresql.org/docs/postgres/storage-toast.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
