Skip site navigation (1) Skip section navigation (2)

Re: Data

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 (view raw or flat)
Thread:
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&nbsp;have a table containing
> about 7.6 mil records but every time I&nbsp;try to do a simple select on
> the table it throws a core dump and segmentation fault. At first it returns
> "backend returns D&nbsp; before T" and then after a while it crashes.
> <br>I&nbsp;did run VACUUM ANALYZE and rebuild my indexes after I&nbsp;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

In response to

  • Data at 2001-06-27 20:09:40 from Phillip Jansen

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-06-27 15:26:40
Subject: Re: functions returning records
Previous:From: Tom LaneDate: 2001-06-27 15:07:38
Subject: Re: Re: Encrypting pg_shadow passwords

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group