Re: [QUESTIONS] libpg - segmentation fault - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [QUESTIONS] libpg - segmentation fault
Date
Msg-id 352D70F7.8D0CA91B@alumni.caltech.edu
Whole thread Raw
List pgsql-hackers
> > I just installed 6.3.1 and am still encountering the same
> > problem in 6.2.1 .. that is... libpq can't manage large query
> > results - -is always returning a segmentation fault . :(
> > select * from foo, bar;
> > - - where foo has 73000 records and bar 22000 records,
> >   both with two fields of char(6) each;
> >   this kind of query (when issued using 'psql') will crash and
> >   returns a 'segmentation fault (core dumped)'
> Holy sh*t, Batman...this is going to return 1.6 _BILLION_ rows!!!!!
> And you're complaining that it dumps core?!?!?!?!?
> Not trying to be _too_ sarcastic, but if you _were_ able to process
> the results for this query at 1000 rows per second around the clock,
> it would take almost three weeks to finish?!?

That's funny :)

                   - Tom

pgsql-hackers by date:

Previous
From: JB
Date:
Subject: Tech questions
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] New pg_type for large object