Re: find close (duplicate) points + create index
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Elinor <elinor@wise1.tau.ac.il>
Cc: pgsql-novice@postgresql.org
Date: 2005-02-16T20:08:48Z
Lists: pgsql-novice
Elinor <elinor@wise1.tau.ac.il> writes:
> After many many minutes, it started giving these lines:
> server sent data ("D" message) without prior row description
> ("T" message)
Up till fairly recently (8.0 or maybe 7.4), libpq would do that if it
ran out of memory to hold the query result. I think you miswrote the
query and it's returning a huge number of rows. If you actually want
to fetch a huge number of rows, try using a cursor ...
regards, tom lane