Postgres Pro
Downloads
Home   >   mailing lists

Re: Expectations of MEM requirements for a DB with large tables. - Mailing list pgsql-general

From Bruce Guenter
Subject Re: Expectations of MEM requirements for a DB with large tables.
Date
Msg-id 20001106083849.A11231@em.ca
Whole thread Raw
In response to RE: Expectations of MEM requirements for a DB with large tables.  ("Michael Miyabara-McCaskey" <mykarz@miyabara.com>)
List pgsql-general
Tree view 
On Sun, Nov 05, 2000 at 10:41:12PM -0800, Michael Miyabara-McCaskey wrote:
> Out of curiosity, if I were using something else besides "psql" would this
> have still been a problem?

Yes.  The library interface in libpq will pull the entire record set
into memory unless you use cursors.
--
Bruce Guenter <bruceg@em.ca>                       http://em.ca/~bruceg/
Attachment

pgsql-general by date:

Previous
From: "Robert D. Nelson"
Date:
Subject: RE: Expectations of MEM requirements for a DB with
Next
From: Marcin Mazurek
Date:
Subject: order of trigger sequence