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?
|
