memory usage and cache query - Mailing list pgsql-general

From ochapiteau
Subject memory usage and cache query
Date
Msg-id 01041112452400.03923@ochapiteau.dagon.pdt
Whole thread Raw
List pgsql-general
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,


pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: Re: JDBC and Perl compiling problems w/ postgresql-7.1rc4
Next
From: Alessio Bragadini
Date:
Subject: Re: personel appliactions?