I'd like to know how many total system files Postgresql has open at any one time.
Is this the easiest way ??
a) Find out how many Postgres process's - `ps aux | grep postgres`
b) For each Postgres process find out which files it has open - `ls /proc/*postgres_process_id*/fd | wc -l`
c) Add up each Postgres process file open total to work out grand total of open files for user Postgres.
I know I can get the total for the whole machine using /proc/user_beancounters but I'd like to know
just for Postgres.
Many thanks Best regards Rudi.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
