From: | Justin Clift <justin(at)postgresql(dot)org> |
---|---|
To: | Steve Wolfe <steve(at)iboats(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: large number of files open... |
Date: | 2002-01-17 02:58:11 |
Message-ID: | 3C463DC3.CE577015@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Steve,
Steve Wolfe wrote:
<snip>
> Our web servers handle a very large number of virtuals domains, so they
> open up a *lot* of log files, and have (at times) hit the same problem
> you're running into. It used to be necessary to recompile the kernel to
> raise the limits, but that ain't so any more, luckily. With 2.4 kernels,
> you can do something like this:
It might be worthwhile taking a look at the program which Matthew
Hagerty wrote called "pgLOGd".
It's designed to get around the need to open heaps of log files, instead
it pipes all the log entries to a single daemon which logs the entries
into a database for later processing.
Not sure how it would work in a virtual domain environment though. :)
http://www.digitalstratum.com/pglogd/
Regards and best wishes,
Justin Clift
> echo '16384' > /proc/sys/fs/file-max
> echo '65536' > /proc/sys/fs/inode-max
>
> or, in /etc/sysctl.conf,
>
> fs.file-max = 16384
> fs.inode-max = 65536
>
> then, /sbin/sysctl -p
>
> Remember that inode-max needs to be at least twice file-max, and if I
> recall, at least three times higher is recommended.
>
> steve
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi
From | Date | Subject | |
---|---|---|---|
Next Message | Elein | 2002-01-17 03:09:27 | Re: Different views with same name for different users |
Previous Message | Justin Clift | 2002-01-17 02:47:26 | Re: Meaning of vacuum output |