Re: [QUESTIONS] libpg - segmentation fault

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Darren King <darrenk(at)insightdist(dot)com>
Cc: Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: Re: [QUESTIONS] libpg - segmentation fault
Date: 1998-04-10 01:08:07
Message-ID: 352D70F7.8D0CA91B@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-04-10 01:15:58 Re: [HACKERS] NetBSD configuration
Previous Message JB 1998-04-10 00:40:20 Tech questions