Re: problem with large maintenance_work_mem settings and

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: problem with large maintenance_work_mem settings and
Дата
Msg-id 6567.1142010172@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: problem with large maintenance_work_mem settings and  ("Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
"Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at> writes:
>>> I'll look into it, but I was already wondering if we shouldn't bound
>>> the number of tapes somehow.  It's a bit hard to believe that 28000 
>>> tapes is a sane setting.
>> 
>> Well, since they are not actually tapes, why not?

> I wonder what the OS does when we repeatedly open and close those files
> because we are short on filedescriptors ?

At the moment, nothing, because all the "tapes" are just I/O buffers on
the same OS-level file (or more accurately, one file per gigabyte of
data).

If we get rid of logtape.c as Luke wants to do, then we might have some
issues here.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Remove Christof Petig copyright on include
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: random observations while testing with a 1,8B row table