Hi Veem, On Tue, Dec 19, 2023 at 7:36 AM veem v <veema0000@xxxxxxxxx> wrote: > 1)For write performance , the rows needs to be inserted from multiple sessions at same time, with required random values as per the data types i.e. Character, Number, date columns. And this needs to be tested for row by row insert and batched insert. > > 2)For the read performance test , the table first has to be populated with those ~100million rows. Then querying will happen on 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 creating a 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@xxxxxxxxxxxxx
