Re: problem with large maintenance_work_mem settings and - Mailing list pgsql-hackers

From Tom Lane
Subject Re: problem with large maintenance_work_mem settings and
Date
Msg-id 6567.1142010172@sss.pgh.pa.us
Whole thread Raw
In response to Re: problem with large maintenance_work_mem settings and  ("Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>)
List 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 by date:

Previous
From: Jan Wieck
Date:
Subject: Re: [COMMITTERS] pgsql: Remove Christof Petig copyright on include
Next
From: Stefan Kaltenbrunner
Date:
Subject: random observations while testing with a 1,8B row table