Re: PG Seg Faults Performing a Query

On Tue, Aug 21, 2007 at 04:38:42PM -0500, Scott Marlowe wrote:
> On 8/21/07, Bill Thoen <bthoen(at)gisnet(dot)com> wrote:
> > How would you suggest I try to track down this problem?
> > I run the following query:
> >
> > SELECT a.* FROM compliance_2006 a, ers_regions b
> > WHERE a.fips_st_cd=b.fips_st
> > AND a.fips_cnty_cd=b.fips_cou AND b.region =1
> > AND a.fips_st_cd='17' AND a.fips_cnty_cd='003';
> >
> > and it works. But when I try this:
> >
> > SELECT a.* FROM compliance_2006 a, ers_regions b
> > WHERE a.fips_st_cd=b.fips_st
> > AND a.fips_cnty_cd=b.fips_cou AND b.region =1
> > AND a.fips_st_cd='17' ;
> >
> > psql dies with the message:
> > Segmentation Fault.
>
> so the client psql is what's dieing right? In that case you likely
> are getting too big a result set for psql to handle at once. Trying
> declaring a cursor to hold your query and fetching 100 or 1000 or so
> rows at a time.
>
> Just guessing. What's the exact text of the error message?
>

The exact message was:

Segmentation Fault.

But the table compliance_2006 is very big (18 million plus records) so I'll
try that cursor idea. But even so, an error like that makes me think that
something's broken.