Re: BUG #1756: PQexec eats huge amounts of memory

From: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>
To: Denis Vlasenko <vda(at)ilport(dot)com(dot)ua>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1756: PQexec eats huge amounts of memory
Date: 2005-07-06 13:52:30
Message-ID: 7be3f35d05070606522a3ec2f9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

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

Harald

--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2005-07-06 14:48:51 Re: Creating trigger function with argument(s) gets backend crash.
Previous Message Michael Fuhr 2005-07-06 13:34:27 Re: Creating trigger function with argument(s) gets backend crash.