"Ed L." <[EMAIL PROTECTED]> writes:
> If we want to handle 16 clusters on this one box, each
> with 300 max_connections and 2000 relations, would it be
> ball-park reasonable to say that worst case we might have 300
> backends with ~2000 open file descriptors each (300 * 2000 =
> 600K open file
On Tuesday March 14 2006 10:46 am, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > 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
"Ed L." <[EMAIL PROTECTED]> writes:
> One lsof curiosity is that one cluster seems to have it's
> partition directory listing open about 10K times, including
> many times by the same backend process:
Nah, that's just an lsof aberration on HPUX --- it doesn't always tell
the truth about files' nam
"Ed L." <[EMAIL PROTECTED]> writes:
> 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
> me
On Tuesday March 14 2006 10:31 am, Ed L. wrote:
> On Tuesday March 14 2006 10:25 am, Tom Lane wrote:
> > "Ed L." <[EMAIL PROTECTED]> 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
On Tuesday March 14 2006 10:25 am, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> 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 tha
"Ed L." <[EMAIL PROTECTED]> 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
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 wo
