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

From Zeugswetter Andreas DCP SD
Subject Re: problem with large maintenance_work_mem settings and
Date
Msg-id E1539E0ED7043848906A8FF995BDA579D994EA@m0143.s-mxs.net
Whole thread Raw
Responses Re: problem with large maintenance_work_mem settings and  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > 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 ? Will it replace cached pages
of a file that we have closed *more* aggressively ?

Maybe we should limit the files to how many files we would actually be
able
to hold open in parallel ? Or keep more that one "tape" in one file
and remember a start offset into the file per tape.

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem with large maintenance_work_mem settings and
Next
From: Jan Wieck
Date:
Subject: Re: [COMMITTERS] pgsql: Remove Christof Petig copyright on include