public inbox for [email protected]
help / color / mirror / Atom feedProblem with large tables
2+ messages / 2 participants
[nested] [flat]
* Problem with large tables
@ 1970-01-01 00:00 Hector Miranda <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Hector Miranda @ 1970-01-01 00:00 UTC (permalink / raw)
To: pgsql-general
Hello!
I'm working with Posgresql 7.0.3 on Red Hat linux 6.2. When I make the
following query "select * from mytable" (2000000 rows), I get the message:
"Backend sent D message whitout prior T" or
"Backend sent B message whitout prior T"
What is the problem?
Plese help me
Thanks
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problem with large tables
@ 2001-04-05 21:38 Tom Lane <[email protected]>
parent: Hector Miranda <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2001-04-05 21:38 UTC (permalink / raw)
To: Hector Miranda <[email protected]>; +Cc: pgsql-general
"Hector Miranda" <[email protected]> writes:
> I'm working with Posgresql 7.0.3 on Red Hat linux 6.2. When I make the
> following query "select * from mytable" (2000000 rows),
You're running out of application memory for the query result. (libpq
doesn't recover from that too gracefully, unfortunately.) Consider
using a cursor to fetch the data in more manageable chunks.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-04-05 21:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1970-01-01 00:00 Problem with large tables Hector Miranda <[email protected]>
2001-04-05 21:38 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox