Re: [SQL] to do's?

Clayton Cottingham <drfrog(at)smartt(dot)com> writes:
> hi i was wondering if multi threading will be enabled soon?

Huh? We already have multiple backends, what advantage would
there be to using threads?

> is that i have a 1.3 mil row db when i try to select all i get memory
> out type errors, either system wide or droping the backend

The problem is probably at the application end --- libpq is built on
the model that it can collect the entire query result in memory and
then give the application random access to that array. So if the
query result won't fit in the space available to the application,
trouble. I don't see why this would affect anything else in your
system, though, unless the app uses up all available swap space and
holds it for a while before crashing...

What you probably want to do instead of a straight SELECT is use
DECLARE CURSOR and FETCH to retrieve the table a few dozen/hundred
rows at a time.

regards, tom lane