Re: PSQL performance - TPS

2019-08-01 Thread Shital A
On Thu, 1 Aug 2019, 23:58 Rick Otten, wrote: > > > On Thu, Aug 1, 2019 at 2:15 PM Andres Freund wrote: > >> Hi, >> >> On 2019-08-01 23:36:33 +0530, Purav Chovatia wrote: >> > > If you've set synchronous_commit = off, and you still get only 1200 >> > > transactions/sec, something else is off.

Re: PSQL performance - TPS

2019-08-01 Thread Rick Otten
On Thu, Aug 1, 2019 at 2:15 PM Andres Freund wrote: > Hi, > > On 2019-08-01 23:36:33 +0530, Purav Chovatia wrote: > > > If you've set synchronous_commit = off, and you still get only 1200 > > > transactions/sec, something else is off. Are you sure you set that? > > I am not very surprised with

Re: PSQL performance - TPS

2019-08-01 Thread Andres Freund
Hi, On 2019-08-01 23:36:33 +0530, Purav Chovatia wrote: > > If you've set synchronous_commit = off, and you still get only 1200 > > transactions/sec, something else is off. Are you sure you set that? > I am not very surprised with these results. However, what’s the disk type? > That can matter

Re: PSQL performance - TPS

2019-08-01 Thread Andres Freund
Hi, On 2019-08-01 08:40:53 +0530, Shital A wrote: > Need help in: > 1. On this env(8core cpu, 16GB) what is the TPS that we can expect? We have > tested with a simple Java code firing insert and commit in a loop on a > simple table with one column. We get 1200 rows per sec. If we increase >