Skip site navigation (1) Skip section navigation (2)

Re: high loads, fine tuning

From: Aras Angelo <araskoktas(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: high loads, fine tuning
Date: 2009-09-29 19:12:04
Message-ID: 5136d4130909291212k5c5ca14egc6d4ade7293dbf36@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Sorry i forgot to mention it, max cli setting is 500.

On Tue, Sep 29, 2009 at 12:07 PM, <lst_hoe02(at)kwsoft(dot)de> wrote:

> Zitat von Aras Angelo <araskoktas(at)gmail(dot)com>:
>
>  I have this server, Dual Intel Xeon 2.83GHz w 4gb ram.
>> My shared buffers were set to 1756 MB.
>>
>> We have a high traffic e-commerce site, yesterday like 80000 uniques.
>> We cache most of our dynamic pages to disk so its wierd we are experience
>> really slow response times with postgresql.
>>
>> Usually the number of simultaneous connections i monitor is around 8 to
>> 10,
>> but yesterday night, maybe there was a spike in the traffic, it was going
>> up
>> to 100, so the pages were taking like 15 seconds to render.
>>
>
> As far as i know the default for max_connections is "100" on many Linux
> Distros. This would explain why your web-app is slow when reaching this
> limit.
>
> Regards
>
> Andreas
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

In response to

pgsql-admin by date

Next:From: Darcy LarangeiraDate: 2009-09-29 21:58:10
Subject: save db
Previous:From: lst_hoe02Date: 2009-09-29 19:07:49
Subject: Re: high loads, fine tuning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group