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: Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> 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
splittingon whitespace    # won't work, because some quoted fields might contain internal    # whitespace.  We handle
thisby folding them all to a simple    # "xxx". Fortunately, this script doesn't need to look at any    # fields that
mightneed 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
Дата:
Сообщение: Re: Somebody has broken autovacuum's abort path