Re: PostgreSQL unsuitable for large datasets? - Mailing list pgsql-cygwin

From Jason Tishler
Subject Re: PostgreSQL unsuitable for large datasets?
Date
Msg-id 20020831235218.GA1964@tishler.net
Whole thread Raw
In response to PostgreSQL unsuitable for large datasets?  ("Michael Labhard" <ince@pacifier.com>)
List 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

pgsql-cygwin by date:

Previous
From: "Michael Labhard"
Date:
Subject: PostgreSQL unsuitable for large datasets?
Next
From: james2000@etang.com
Date:
Subject: ADV: Harvest lots of E-mail addresses quickly !