Jean-Marc Lessard <Jean-Marc.Lessard@xxxxxxxxxxxx> writes: > Would you recommend bytea over LOB considering that the max LOB size is well bellow 1GB? Yes, probably. The reason that pg_dump has trouble with lots of small BLOBs is the 9.0-era decision to treat BLOBs as independent objects having their own owners, privilege attributes, and archive TOC entries --- it's really the per-BLOB TOC entries that are causing the issue for you here. That model is fine as long as BLOBs are, uh, large. If you're using them as replacements for bytea, the overhead is going to be prohibitive. regards, tom lane
