title: What is the maximum number of records that can be retrieved by postgreSQL?
body: <p>When retrieving records using <code>SELECT</code> 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 <code>LIMIT</code> and <code>OFFSET</code>?</p>