| Lists: | pgsql-hackers |
|---|
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Phillip Jansen <pfj(at)ucs(dot)co(dot)za> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Data |
| Date: | 2001-06-27 15:10:13 |
| Message-ID: | 8333.993654613@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Phillip Jansen <pfj(at)ucs(dot)co(dot)za> writes:
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Hi
> <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??
> <p>Phillip</html>
(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
| From: | Phillip Jansen <pfj(at)ucs(dot)co(dot)za> |
|---|---|
| To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Data |
| Date: | 2001-06-27 20:09:40 |
| Message-ID: | 3B3A3D84.18EEF7F@ucs.co.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi
<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??
<p>Phillip</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 494 bytes |