[ILUGC] Re: Reg : stress test for postgresSQL
- From: Arun Khan <knura9@xxxxxxxxx>
- To: ILUG-Chennai <ilugc@xxxxxxxxxxxxx>
- Date: Fri, 21 Apr 2017 12:30:42 +0530
On Mon, Apr 17, 2017 at 9:44 PM, Shakthi Kannan <shakthimaan@xxxxxxxxx> wrote:
Hi,
--- On Mon, Apr 17, 2017 at 5:17 PM, Karthikeyan U
<karthi.linux.91@xxxxxxxxx> wrote:
| i want any SQL query or script for increase the CPU usage.
\--
Try the "stress" package to increase load on CPU:
http://www.tecmint.com/linux-cpu-load-stress-test-with-stress-ng-tool/2/
Going from the subject line, I think the OP wants to stress test
postgres. There are several factors to consider besides CPU -- RAM,
Disk I/O, Network I/O. A couple of years ago, I had used 'pgbench'
to size out a postgres server for an e-commerce site.
@ OP -- a simple search "postgresql stress test" throws up "pgbench"
as the first link!
HTH
-- Arun Khan
_____________________________________
ILUGC List:
//www.freelists.org/list/ilugc
ILUGC Web:
http://ilugc.in/
Other related posts: