Andrew Nosenko <awn(at)bcs(dot)zp(dot)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