Re: Memory Usage

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