From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Lincoln Yeoh <lylyeoh(at)mecomb(dot)com> |
Cc: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com>, Serge Sozonoff <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-22 01:20:46 |
Message-ID: | 200002220120.UAA20677@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> At 03:28 PM 21-02-2000 -0600, Ed Loehr wrote:
>
> >Your numbers do not surprise me at all. Backend pgsql servers live
> >for the lifetime of the client connection, and they open a similarly
> >large number of files on my system. I throttle them by throttling the
> >life of the apache children who are generally the only clients.
>
> Oh, the poor little kiddies. Looks like I may have to commit genocide from
> time to time as well. <grin>.
>
> But doesn't the backend close the files after it's done with em? Or it
> doesn't know when it's done with the files?
>
> I've really nothing against native americans, is there a way to throttle or
> fix our good ol elephant instead?
Keeps files open in the expectation it may need them again.
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Loehr | 2000-02-22 01:32:56 | Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0) |
Previous Message | Lincoln Yeoh | 2000-02-22 01:19:47 | Re: [GENERAL] Multiple-row text |