Search Postgresql Archives

PGresult pointer and memory usage

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



When you do a PQexec call in libpq, does PostgreSQL produce the entire
result in memory on the server side, and then does libpq hold the entire
result in memory after it retrieves it?

The only time that the server sends parts of the result at a time is
with a cursor, right? And libpq always holds the data that it gets back,
right?

I guess what I'm asking is, where is the PGresult data actually stored,
and how much of it is stored in the client application at a time?

Regards,
	Jeff Davis


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux