Stefan Kaltenbrunner escribió: > foreach my $row (@$data) > { > > # To construct fmgroids.h and fmgrtab.c, we need to inspect some > # of the individual data fields. Just splitting on whitespace > # won't work, because some quoted fields might contain internal > # whitespace. We handle this by folding them all to a simple > # "xxx". Fortunately, this script doesn't need to look at any > # fields that might need quoting, so this simple hack is > # sufficient. > > ... > } > > it does after around 1050 iterations of that loop at it seems to > leak exactly 240kbyte per iteration which sums up to around 250MB in > total for the process...
Hmm, is this running some old Perl version? Perhaps it's not freeing memory timely ... maybe unsetting/deleting $row after each iteration? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers