"Brandon Keepers" <bkeepers@gmail.com> writes:
> On 3/13/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Ugh :-( How many blobs have you got, thousands?
> Looks like there's over 17,000 blobs. :( But they're all very small,
> if that makes a difference.
No, it's just the number of 'em that counts.
>> Another possibility is to increase the lock table size, but that would
>> probably require recompiling the 7.0 backend. If you're lucky,
>> increasing max_connections to the largest value the backend will support
>> will be enough.
> I'm not the admin of the box that this database is on, so I don't have
> any control over it. I'm working on moving it to a box that I am the
> admin of. But anyway, it sounds like this wouldn't work anyway since
> I have so many blobs.
7.0 sets the lock table size to 64 * max_connections, so if you can
crank max_connections up to 300 or so you should be able to dump.
I think this will work ... it's definitely worth a shot before you
start thinking about hacking the code.
regards, tom lane