| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | "Williams, Travis L, NPONS" <tlw(at)att(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: table overflow question |
| Date: | 2002-10-19 03:41:34 |
| Message-ID: | 15349.1034998894@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Looks like you've run into a open file limit. If you're using linux you
> should look in /proc/sys/fs to make sure you can actually open the number of
> files you need. You should estimate at least 40 files per server.
> I think file-max is the one you want.
He said he was using HPUX. On HPUX 10.20, the kernel parameters NFILE
and NINODE would be the things to bump up; I suspect 11 is the same.
The other direction to attack it from is to reduce PG's parameter
MAX_FILES_PER_PROCESS, but if you have to set that lower than 100
or so then you'd be better advised to fix the kernel.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Williams, Travis L, NPONS | 2002-10-19 03:57:14 | Re: table overflow question |
| Previous Message | Martijn van Oosterhout | 2002-10-19 03:18:45 | Re: table overflow question |