Re: Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial

Поиск
Список
Период
Сортировка
Искать
От
Stefan Kaltenbrunner
Тема
Re: Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial
Дата
Msg-id
4B438877.3010903@kaltenbrunner.cc
Ответ на
Список
Дерево обсуждения
Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial Tom Lane <tgl@sss.pgh.pa.us>
Tom Lane wrote:
> Robert Haas  writes:
>> Beats me.  I don't have any other ideas at the moment.
> 
> Stefan, could you try adding some debugging printouts to the
> Gen_fmgrtab.pl script to see how far it gets before blowing up?

did that and it seems the problem is in the loop that does:

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...


Stefan

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: Writeable CTEs
От: Simon Riggs
Дата:
FAQ