Phillip Jansen <pfj(at)ucs(dot)co(dot)za> writes:
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <p>I trying to compare oracle vs postgresql , so I have a table containing
> about 7.6 mil records but every time I try to do a simple select on
> the table it throws a core dump and segmentation fault. At first it returns
> "backend returns D before T" and then after a while it crashes.
> <br>I did run VACUUM ANALYZE and rebuild my indexes after I loaded
> the data.
> <p>Any ideas??
(1) Please don't send HTML-ified mail to the lists.
(2) You're running out of memory for the SELECT result on the client
side. libpq is not presently very graceful about that, unfortunately.
But did you really want to retrieve all 7.6 million rows at once?
regards, tom lane
In response to
- Data at 2001-06-27 20:09:40 from Phillip Jansen
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2001-06-27 15:26:40|
|Subject: Re: functions returning records |
|Previous:||From: Tom Lane||Date: 2001-06-27 15:07:38|
|Subject: Re: Re: Encrypting pg_shadow passwords |