Henry <henry@zen.co.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