Re: Expectations of MEM requirements for a DB with large tables.

From: Bruce Guenter <bruceg(at)em(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Expectations of MEM requirements for a DB with large tables.
Date: 2000-11-06 14:38:50
Message-ID: 20001106083849.A11231@em.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)em(dot)ca> http://em.ca/~bruceg/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Mazurek 2000-11-06 14:45:48 order of trigger sequence
Previous Message Jarmo Paavilainen 2000-11-06 14:00:19 default timestamp and default autoinc