Tom Lane wrote on Tue, 12 Jun 2001 19:28:14 EDT
>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.
>
Thanks Tom! We are still testing but 7.1 seems to have fixed the
problem (yes, it was 7.0). There are probably better ways of doing
two-point correlation functions. I suppose what we really need here
is some sort of spatial hash.
--Martin