Re: PostgreSQL unsuitable for large datasets?

From: Jason Tishler <jason(at)tishler(dot)net>
To: Michael Labhard <ince(at)pacifier(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: PostgreSQL unsuitable for large datasets?
Date: 2002-08-31 23:52:18
Message-ID: 20020831235218.GA1964@tishler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Michael,

On Sat, Aug 31, 2002 at 11:48:19AM -0700, Michael Labhard wrote:
> We have a PostgreSQL (7.2.1) database on cygwin with one table that
> contains some 2 x 10**6 records. The database is about 100 MB total.
> This does not seem so large, but while attempting to do an insert into
> an empty table using a select that joins to the large table on all the
> rows the error,
>
> Memory exhausted in AllocSetAlloc(36)

Does the following help?

http://sources.redhat.com/ml/cygwin/2000-04/msg00267.html

Jason

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message james2000 2002-09-01 08:43:24 ADV: Harvest lots of E-mail addresses quickly !
Previous Message Michael Labhard 2002-08-31 18:48:19 PostgreSQL unsuitable for large datasets?