Re: BUG #1756: PQexec eats huge amounts of memory - Mailing list pgsql-bugs

From Harald Armin Massa
Subject Re: BUG #1756: PQexec eats huge amounts of memory
Date
Msg-id 7be3f35d05070606522a3ec2f9@mail.gmail.com
Whole thread Raw
In response to BUG #1756: PQexec eats huge amounts of memory  ("Denis Vlasenko" <vda@ilport.com.ua>)
Responses Re: BUG #1756: PQexec eats huge amounts of memory  (Denis Vlasenko <vda@ilport.com.ua>)
List pgsql-bugs
Denis,

$result =3D pg_query($db, "SELECT * FROM big_table");
>=20

you are reading a big result (as I suspect from big_table) into memory. It=
=20
is perfectly normal that this uses large amounts of memory.

[it would be rather suspicious if loading a big file / big resultset would=
=20
not use big amounts of memory]

Harald


--=20
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstra=DFe 202b
70197 Stuttgart
0173/9409607

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Creating trigger function with argument(s) gets backend crash.
Next
From: Bruce Momjian
Date:
Subject: Re: Creating trigger function with argument(s) gets backend crash.