Re: PostgreSQL unsuitable for large datasets?

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