Re: memory allocation

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: nijam J <nijamutheenblogs1(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: memory allocation
Date: 2017-10-19 12:51:59
Message-ID: 1508417519.2574.18.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

nijam J wrote:
> our server is getting too slow again and again

Use "vmstat 1" and "iostat -mNx 1" to see if you are
running out of memory, CPU capacity or I/O bandwith.

Figure out if the slowness is due to slow queries or
an overloaded system.

Yours,
Laurenz Albe

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jean Baro 2017-10-19 16:10:12 Low priority batch insert
Previous Message Joe Carlson 2017-10-17 22:18:49 Re: Row level security policy policy versus SQL constraints. Any performance difference?