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
?
CodePudding user response:
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.