Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] memory allocation - Mailing list pgsql-performance

From Laurenz Albe
Subject Re: [PERFORM] memory allocation
Date
Msg-id 1508417519.2574.18.camel@cybertec.at
Whole thread Raw
In response to [PERFORM] memory allocation  (nijam J <nijamutheenblogs1@gmail.com>)
List pgsql-performance
Tree view 
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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Joe Carlson
Date:
Subject: Re: [PERFORM] Row level security policy policy versus SQLconstraints. Any performance difference?
Next
From: Jean Baro
Date:
Subject: [PERFORM] Low priority batch insert