Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0)

From: Lincoln Spiteri <lincoln(dot)spiteri(at)st(dot)com>
To: pgman(at)candle(dot)pha(dot)pa(dot)us, pgman(at)candle(dot)pha(dot)pa(dot)us
Cc: serge(at)globalbeach(dot)com, pgsql-general(at)postgreSQL(dot)org
Subject: Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0)
Date: 2000-02-28 14:02:01
Message-ID: 00022815404900.32534@voltaire.kir.st.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Even after extending the number of file descriptors on the kernel quite
significantly I still get the occasional crash due to too many open files. I
would say that the current ploicy is too aggressive uder heavy loads.

Regards
Lincoln

On Mon, 28 Feb 2000, pgman(at)candle(dot)pha(dot)pa(dot)us wrote:

>
> This actually brings up a good point. We currently cache all
> descriptors up to the limit the OS will allow for a process.
>
> Is this too aggressive? Should we limit it to 50% of the maximum?
>
>
> --
> Bruce Momjian | http://www.op.net/~candle
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
> ************
--
------------------------------------------------------------------------------

Lincoln Spiteri

Manufacturing Systems
STMicroelectronics, Malta

e-mail: lincoln(dot)spiteri(at)st(dot)com

------------------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip 2000-02-28 14:16:55 Apache Server
Previous Message Ulf Mehlig 2000-02-28 12:06:02 psql 7.0.0 beta