Sorry about the formatting.
I am posting the same lines again.
I am working in a public company who uses only open source applications and
databases. I have a problem with our critical database which is write and
read intensive.
version: Postgresql-9.4
Hardware: HP DL980 (8-processor, 80 cores
On 2015-10-03 01:39:33 -0700, ajaykbs wrote:
> It is observed that at some times during moderate load
> the CPU usage goes up to 400% and the users are not able to complete the
> queries in expected time. But the load is contributed by some system process
> only.The average connections are normally
Are you using any connection pooler in front of the database?
On 3 Oct 2015 17:04, "Gavin Flower" wrote:
> On 03/10/15 21:39, ajaykbs wrote:
>
>> I am working in a public company who uses only open source applications
>> and databases. I have a problem with our critical database which is write
>>
On 03/10/15 21:39, ajaykbs wrote:
I am working in a public company who uses only open source
applications and databases. I have a problem with our critical
database which is write and read intensive. *version:* Postgresql-9.4
*Hardware:* HP DL980 (8-processor, 80 cores w/o hyper threading, 512G
I am working in a public company who uses only open source applications and
databases.I have a problem with our critical database which is write and
read intensive.*version:* Postgresql-9.4*Hardware:* HP DL980 (8-processor,
80 cores w/o hyper threading, 512GB RAM)*Operating system: *Red Hat
Enterpr
