Re: Merge join exhausting swap space - Mailing list pgsql-general

From Tom Lane
Subject Re: Merge join exhausting swap space
Date
Msg-id 16390.992388494@sss.pgh.pa.us
Whole thread Raw
In response to Merge join exhausting swap space  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
Responses Re: Merge join exhausting swap space  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
List pgsql-general
Martin Weinberg <weinberg@osprey.astro.umass.edu> writes:
> As long as the input table (in this case, may14_goodsrc) is small
> enough it works fine.  For large input tables, postgres exhausts
> all swap space and crashes.

What Postgres version?

If it's 7.0, try 7.1.

            regards, tom lane

pgsql-general by date:

Previous
From: GH
Date:
Subject: Re: Unique rows without a key
Next
From: GH
Date:
Subject: Re: Adding a primary key