> Application as a whole is expected to give an throughput of 100k
transactions per sec.
> On this env(8core cpu, 16GB) what is the TPS that we can expect?
as a reference - maybe you can reuse/adapt the "TechEmpower Framework
Benchmarks" tests - and compare your PG9.6+hardware results.
The new T
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. Are
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 th
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 qui
I am not very surprised with these results. However, what’s the disk type?
That can matter quite a bit.
On Thu, 1 Aug 2019 at 10:51 PM, Andres Freund wrote:
> 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 e
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
> thread
Hello,
Version 9.6 is used because the components interacting with DB support this
version. OS is RHEL 7.6.
Thanks!
On Thu, 1 Aug 2019, 10:45 Gavin Flower,
wrote:
> On 01/08/2019 15:10, Shital A wrote:
> > Hello,
> >
> > We are working on development of an application with postgresql 9.6 as
>
On 01/08/2019 15:10, Shital A wrote:
Hello,
We are working on development of an application with postgresql 9.6 as
backend. Application as a whole is expected to give an throughput of
100k transactions per sec. The transactions are received by DB from
component firing DMLs in ad-hoc fashion i
Hello,
We are working on development of an application with postgresql 9.6 as
backend. Application as a whole is expected to give an throughput of 100k
transactions per sec. The transactions are received by DB from component
firing DMLs in ad-hoc fashion i.e. the commits are fired after random
num
