Обсуждение: what if PQexec() result is toooooo big?

Поиск
Список
Период
Сортировка

what if PQexec() result is toooooo big?

От
"Aggarwal , Ajay"
Дата:
What happens when the PQexec(..) result is too big to return in one single
response message? Say you are reading a table with millions of entries. Is
there a way to write one single PQexec() request but read the result in
chunks :

  "give me the first 500 tuples",
  "give me the next 500",
   and so on... until you read the entire table.

How does postgres handle these situations?

Ajay