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.