[PERFORM] postgresql tuning with perf

2017-10-23 Thread Purav Chovatia
Hello Experts, We are trying to tune our postgresql DB using perf. We are running a C program that connects to postgres DB and calls very simple StoredProcs, one each for SELECT, INSERT & UPDATE. The SPs are very simple. *SELECT_SP*: CREATE OR REPLACE PROCEDURE query_dept_new(p1 IN numeric, p2 OU

Re: [PERFORM] postgresql tuning with perf

2017-10-23 Thread legrand legrand
Hi, could you providence the code used with PG ? Has table dept_new an index/pk on c1 ? Do you analyze this table after loading it ? Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html -- Sent via pgsql-performance mailing list (pgsql-performa

Re: [PERFORM] postgresql tuning with perf

2017-10-23 Thread Tomas Vondra
On 10/23/2017 09:19 PM, Purav Chovatia wrote: > Hello Experts, > > We are trying to tune our postgresql DB using perf. Can you share some of the perf reports, then? > We are running a C program that connects to postgres DB and calls > very simple StoredProcs, one each for SELECT, INSERT & UPDA

Re: [PERFORM] postgresql tuning with perf

2017-10-23 Thread Steve Atkins
> On Oct 23, 2017, at 12:19 PM, Purav Chovatia wrote: > > Hello Experts, > > We are trying to tune our postgresql DB using perf. We are running a C > program that connects to postgres DB and calls very simple StoredProcs, one > each for SELECT, INSERT & UPDATE. > > The SPs are very simple.