On Tuesday March 14 2006 10:25 am, Tom Lane wrote: > "Ed L." <pgsql@xxxxxxxxxxxxx> writes: > > We're trying to make sense of the number of open files on an > > HP-UX 11.23 system that's getting several new 8.1.2 > > clusters, and in particular why the numbers appear to be > > significantly larger than our 7.4 clusters on similar > > hardware. Would there be anything particular to 8.1.2 over > > 7.4 that would lead to a larger number of open files? > > This is much too handwavy to provide an intelligent comment > on. Get a copy of "lsof" and find out exactly which processes > have how many files open, then we'll have some idea what's > going on... We have 3 clusters with 24K, 34K, and 47K open files according to lsof. These same clusters have 164, 179, and 210 active connections, respectively. Their schemas, counting the number of user and system entries in pg_class as a generously rough measure of potential open files, contain roughly 2000 entries each. Those open files seem pretty plausible, they're just much higher than what we see on the older systems. Ed
