I wrote: >> This is computing obj_description() redundantly for each pg_largeobject >> chunk. Perhaps there is a memory leak in obj_description() in 7.3.2? Actually, obj_description() is a SQL-language function, and we had horrendous problems with end-of-function-call memory leakage in SQL functions in every version before 7.4. So this is undoubtedly the source of Jeff's problem. Jeff Frost <jeff@xxxxxxxxxxxxxxxxxxxxxx> writes: > I'll alter pg_dump and recompile, then give a test. Does pg_dumpall just call > pg_dump or do I need to change it there too? pg_dumpall calls pg_dump, so only one place to fix. I've already committed the fix in CVS, if you'd prefer to use a tested patch. http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c.diff?r1=1.422.2.3;r2=1.422.2.4 regards, tom lane
