What is the optimal execution time for Reading 200k records in Postgres. We had issues for reading records in cassandra which faced time out for ~200K records.
any ideal solution or recommendation towards Postgres.
Cassandra is highly optimized for key based readings only.
Without knowing your application it is hard to predict how long will it take to read 200K records.
Does the query to fetch 200K records use index.
Does it fetch a small portion or a large portion of total rows. If later, then most likely PG will do table scan.
How wide is the table.
What is the timeout setting?