| 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: | Whole Thread | Raw Message | 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 |