What are your settings for SHMMAX and max files? - Mailing list pgsql-general

From adb
Subject What are your settings for SHMMAX and max files?
Date
Msg-id Pine.GSO.4.10.10103021204190.2561-100000@hairdini.beast.com
Whole thread Raw
List pgsql-general
Hi, I'm trying to figure out what some reasonable settings would
be for kernel parameters like shared memory and max open files.
I've read the section of the manual but it doesn't seem to give
any rule of thumb based on number of users or frequency of queries.

With my load testing I definitely bump up against the max open files
problem but I'm not sure about the shared memory.

I'm running linux (redhat 6.1)

If you have a high volume production system, can you post your
parameter settings and anything you tweak at startup?

Thanks,

Alex.


pgsql-general by date:

Previous
From: adb
Date:
Subject: Re: Re: serial properties
Next
From: will trillich
Date:
Subject: Re: how to examin the database structure with an sql command