"Mavinakuli, Prasanna (STSD)" <[EMAIL PROTECTED]> writes:
> We have observed that postgres opens many files in data directory
> And won't close till next vacuum (I experience it)
> When it hits max limit, we won't able to open any other files.
> So what's the solution ..?
Reduce PG's max_files_p
Hello All,
We are using postgres with HP-UX.
Usually We will have many records,and will do vacuum once in 2 days.
We have observed that postgres opens many files in data directory
And won't close till next vacuum (I experience it)
When it hits max limit, we won't able to open any other files.
S
Also (obvsly) we aren't able to get a new connection after hitting max
fd limit..
Thx,
Prasanna.
-Original Message-
From: Mavinakuli, Prasanna (STSD)
Sent: Wednesday, August 09, 2006 10:10 AM
To: pgsql-general@postgresql.org
Cc: Mavinakuli, Prasanna (STSD)
Subject: Too many open files fr
