Re: problem with large maintenance_work_mem settings and

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zeugswetter Andreas DCP SD" <ZeugswetterA(at)spardat(dot)at>
Cc: "Simon Riggs" <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: problem with large maintenance_work_mem settings and
Date: 2006-03-10 17:02:52
Message-ID: 6567.1142010172@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Zeugswetter Andreas DCP SD" <ZeugswetterA(at)spardat(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2006-03-10 17:20:51 Re: pgsql: Remove Jan Wieck's name from copyrights,
Previous Message Jan Wieck 2006-03-10 17:00:04 Re: [COMMITTERS] pgsql: Remove Christof Petig copyright on include