Re: Memory Usage - Mailing list pgsql-general

From Tom Lane
Subject Re: Memory Usage
Date
Msg-id 7812.976557168@sss.pgh.pa.us
Whole thread Raw
In response to Re: Memory Usage  (Andrew Nosenko <awn@bcs.zp.ua>)
List pgsql-general
Andrew Nosenko <awn@bcs.zp.ua> writes:
> When SELECT is executing Postgres (7.0.3) allocate how many memory as
> need for store full result set of query.

The *client* does that (if it uses libpq).  Not the server.  A user can
only crash his own client if he retrieves an oversize result set.

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Nosenko
Date:
Subject: Re: Memory Usage
Next
From: Bruce Momjian
Date:
Subject: Re: Great Bridge PostgreSQL products and services