On Mon, 2006-12-11 at 17:50 -0600, Kirk Wythers wrote: > SELECT count (*) returns 33,061,700 > > met_data=# SELECT count(*) FROM climate, sites, solar WHERE > climate.id = sites.id AND solar.id = sites.id AND climate.year = 1999; > ---------- > 33061700 > (1 row) > > However attempting the join > met_data=# SELECT climate.year, solar.doy, sites.longname FROM > climate, sites, solar WHERE climate.id = sites.id AND solar.id = > sites.id AND climate.year = 1999; > > gives the error. > > > psql(394) malloc: *** vm_allocate(size=396742656) failed (error code=3) > psql(394) malloc: *** error: can't allocate region > psql(394) malloc: *** set a breakpoint in szone_error to debug > out of memory > That's a client-side error. Why are you trying to return 33M records to the client? Regards, Jeff Davis
