Hi Veem,
On Tue, Dec 19, 2023 at 7:36 AM veem v <veema0000@gmail.com> wrote:
> 1)For write performance , the rows needs to be inserted from multiple sessions at same time, with required random
valuesas per the data types i.e. Character, Number, date columns. And this needs to be tested for row by row insert and
batchedinsert.
>
> 2)For the read performance test , the table first has to be populated with those ~100million rows. Then querying will
happenon that table row by row and batched way from the concurrent session.
>
> I am new to postgresql but mostly worked with Oracle, so I wanted to understand if the above can be achieved by
creatinga simple procedure or will a major effort be needed? And I saw a few blogs , pgbench to be used for concurrency
tests.
Yes, you are right, pgbench with customized script is what you are looking for
>I want to know if this will still work on Aurora postgresql from intellij client worksheet.
pgbench would work with aurora as with normal postgres, it is
basically a shell script which connects to the database. Not sure if
idea worksheet would help you in such case however, you can run it
just from any machine with pgbench installed
Best regards,
Ilya
--
Ilya Kosmodemiansky
CEO, Founder
Data Egret GmbH
Your remote PostgreSQL DBA team
T.: +49 6821 919 3297
ik@dataegret.com