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