From: Tom Lane <tgl@sss.pgh.pa.us>
To: Clayton Cottingham <drfrog@smartt.com>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] to do's?
Date: Wed, 15 Sep 1999 09:53:02 -0400
Message-ID: <19073.937403582@sss.pgh.pa.us> (raw)
In-Reply-To: <37DEC3E1.59071869@smartt.com>
Clayton Cottingham <drfrog@smartt.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, drfrog@smartt.com
Subject: Re: [SQL] to do's?
In-Reply-To: <19073.937403582@sss.pgh.pa.us>
References: <37DEC3E1.59071869@smartt.com> <19073.937403582@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox