From: | veem v <veema0000(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Read write performance check |
Date: | 2023-12-19 06:36:33 |
Message-ID: | CAB+=1TVWinj5Zo4K_=LsR74cafhhEo0Zh==sdybaQ+ZO5UtWJQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello All,
Its Aurora postgresql database in AWS. We have a couple of custom tables
created with some ~100 odd columns and required indexes and constraints
created on them and that represents a certain business use case. Currently
we don't have any data in them. Requirement is to test read and write
queries performance for this sample use cases/tables. We need to evaluate
both row by row and batch read/write performance. Also performance with
concurrent read/write from multiple threads/sessions.
As i understand below things to be done here,
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. I want to know if this will still work on Aurora
postgresql from intellij client worksheet.
Regards
Veem
From | Date | Subject | |
---|---|---|---|
Next Message | Ilya Kosmodemiansky | 2023-12-19 07:27:35 | Re: Read write performance check |
Previous Message | Piergiorgio Valli | 2023-12-18 16:36:25 | Re: Postgresql 15 client arm64 and Qt 5.15 |