That seems to have killed it. I am now running
select gid from csn_waterbodies where not isvalid(the_geom)
and not going above 6Mb.
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey at refractions.net
| Phone: (250) 885-0632
\_