Re: Read write performance check

Veem, first things first... "Top Posting" is when you reply at the top of the email...  Notice how I replied at the bottom (and I deleted context, clearly).
This is the style we prefer here.

Second, since you are new to postgreSQL... Let me recommend some reading.  Cybertec has articles on performance (Tom Kyte style).
Also, read the "Don't Do That" wiki, and finally, have a look at pgbench and psql documentation.  And specifically look at GENERATE_SERIES(),
but the Cybertec articles will touch on that.  Regardless...  Reading the docs is insightful.

Links:
https://www.cybertec-postgresql.com/en/postgresql-hash-index-performance/
https://wiki.postgresql.org/wiki/Don't_Do_This
https://www.postgresql.org/docs/current/app-psql.html
https://www.postgresql.org/docs/current/pgbench.html
https://www.postgresql.org/docs/16/functions-srf.html

HTH,

Kirk Out!