| From: | denis(at)edistar(dot)com |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, Jeff Trout <threshar(at)torgo(dot)978(dot)org>, Richard Huxton <dev(at)archonet(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgresql with max_connections=4096 |
| Date: | 2005-07-28 07:20:48 |
| Message-ID: | 42E88750.6080201@edistar.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
With the last test I made, the database is swapping but in a very slow
way... 100K every 10 minutes and that seems to not be a problem... in
the sense that the server doesn't slow down...
Today I'll make other tests and let you know.
Thank you,
Denis
Scott Marlowe wrote:
>On Wed, 2005-07-27 at 12:53, Jim C. Nasby wrote:
>
>
>>On Wed, Jul 27, 2005 at 04:46:56PM +0200, denis(at)edistar(dot)com wrote:
>>
>>
>>>I'm now testing with pg_pool installed on each apache frontend with 260
>>>pg_pool preforked clients in each machine.
>>>
>>>The database seems to work better. At least when it goes to swap it
>>>doesn't stop working...
>>>
>>>
>>Wait, are you saying your database server is swapping? You'll never get
>>any kind of performance if that's the case.
>>
>>
>
>IF it swaps out unused code / data and leaves it, that's fine, but if
>it's constantly swapping out then yeah, that's a VERY bad thing.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2005-07-28 07:55:56 | Re: MySQL to PostgreSQL, was ENUM type |
| Previous Message | denis | 2005-07-28 07:18:29 | Re: Postgresql with max_connections=4096 |