Re: [GENERAL] too-may-open-files log file entries when vauuming under solaris

2014-03-07 Thread Raschick, Hartmut
> -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Wednesday, March 5, 2014 9:17 PM > To: Raschick, Hartmut > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] too-may-open-files log file entries when > vauuming under solaris > >

Re: [GENERAL] too-may-open-files log file entries when vauuming under solaris

2014-03-05 Thread Tom Lane
"Raschick, Hartmut" writes: > recently we have seen a lot of occurrences of "out of file descriptors: > Too many open files; release and retry" in our postgres log files, every > night when a "vacuum full analyze" is run. After some digging into the > code we found that postgres potentially tries