Thread: memory usage and cache query

memory usage and cache query

From
ochapiteau
Date:
My process in php submit about 1000 querys (in a while) like :
"INSERT INTO table SELECT id from table2 where ..."
This type of query for me does'nt require any memory in the php process (all to
postgres process)
is use pg_exec and pg_freeresult just after each query call.

But when this script run, the memory use of the httpd process grow to 70 Mb!
Is it possible to disable this "uneeded" memory use in the httpd process ?

Is there a query cache which i can disable ?(no query are used 2 times).

Which the use of this memory ?

thanks,