Thanks@verymuch.com wrote:
> Does php need to read database everytime when pg_fetch_array is executed in
> the while loop or all the rows have been in the memory after pg_query?
The latter - pg_query puts all of the rows in memory. I found this out myself recently. Select a
lot of rows using pg_query without pg_fetch_array. As you're doing this, watch he memory usage
with 'free -s 1'.
George Essig