When retrieving records using SELECT in postgres, what is maximum number of records that can be retrieved? Can it return a maximum of 10 million records at a single time if I wanted it too? Or can it only return a specific amount (ex. 5,000) in order to encourage using LIMIT and OFFSET?
What is the maximum number of records that can be retrieved by postgreSQL?
Viewed 453
1 Answers
There is no limit to the number of result rows in a query.
If your client collects the whole result in memory, that poses a limit, but most clients can be configured not to do that.
Related