[BUGS] BUG #1756: PQexec eats huge amounts of memory

2005-07-06 Thread Denis Vlasenko
The following bug has been logged online: Bug reference: 1756 Logged by: Denis Vlasenko Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux Description:PQexec eats huge amounts of memory Details: Verbatim from http://bugs.php.net

Re: [BUGS] BUG #1756: PQexec eats huge amounts of memory

2005-07-07 Thread Denis Vlasenko
On Wednesday 06 July 2005 16:52, Harald Armin Massa wrote: > Denis, > > $result = pg_query($db, "SELECT * FROM big_table"); > > you are reading a big result (as I suspect from big_table) into memory. It > is perfectly normal that this uses large amounts of memory. No, I am not reading it into m

Re: [BUGS] BUG #1756: PQexec eats huge amounts of memory

2005-07-07 Thread Denis Vlasenko
On Thursday 07 July 2005 08:54, Neil Conway wrote: > Denis Vlasenko wrote: > > Symptom: even the simplest query > > $result = pg_query($db, "SELECT * FROM big_table"); > > eats enormous amounts of memory on server > > (proportional to table size). > > Ri

Re: [BUGS] BUG #1756: PQexec eats huge amounts of memory

2005-07-11 Thread Denis Vlasenko
On Thursday 07 July 2005 20:43, Alvaro Herrera wrote: > On Thu, Jul 07, 2005 at 08:17:23AM -0700, John R Pierce wrote: > > Neil Conway wrote: > > >Denis Vlasenko wrote: > > > > > >>The same php script but done against Oracle does not have this > > >

Re: [BUGS] BUG #1756: PQexec eats huge amounts of memory

2005-07-13 Thread Denis Vlasenko
On Monday 11 July 2005 03:38, Alvaro Herrera wrote: > On Sun, Jul 10, 2005 at 01:05:10PM +0300, Denis Vlasenko wrote: > > On Thursday 07 July 2005 20:43, Alvaro Herrera wrote: > > > > Really? I thought what really happened is you had to get the results > > > on

Re: [BUGS] BUG #1756: PQexec eats huge amounts of memory

2005-07-13 Thread Denis Vlasenko
On Wednesday 13 July 2005 17:43, Tom Lane wrote: > Denis Vlasenko <[EMAIL PROTECTED]> writes: > > Consider my posts in this thread as user wish to > > * libpq and network protocol to be changed to allow for incremental reads > > of executed queries and for multi