Home > Mobile >  What is the maximum number of records that can be retrieved by postgreSQL?
What is the maximum number of records that can be retrieved by postgreSQL?

Time:10-13

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.

  • Related