| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Henry <henry(at)zen(dot)co(dot)za> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Excessive (?) Pg file descriptor use when partitioning |
| Date: | 2009-05-23 22:31:42 |
| Message-ID: | 13397.1243117902@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Henry <henry(at)zen(dot)co(dot)za> writes:
> However, once I start real processing and there's lots of updates and
> selects occurring, file descriptor usage (by many Pg procs) will
> gleefully claw it's way up to 400k (on the busy cluster master node)
> and eventually bludgeon my arbitrary 500k limit. Each Pg process eats
> about 991 fd's.
You can adjust that with max_files_per_process. I wouldn't make it
too small though.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-05-23 22:41:20 | Re: 8.3: timestamp subtraction |
| Previous Message | Havasvölgyi Ottó | 2009-05-23 21:38:43 | Re: 8.3: timestamp subtraction |