Re: PG Seg Faults Performing a Query

On Wed, Aug 22, 2007 at 07:09:22AM -0600, Bill Thoen wrote:
> PostgreSQL Version is 8.1.5, running on Linux (Fedora Core 6). The last few
> lines in the Serverlog are:
> LOG: unexpected EOF on client connection
> LOG: transaction ID wrap limit is 1073746500, limited by database
> "postgres"
> LOG: transaction ID wrap limit is 1073746500, limited by database
> "postgres"

All indications are that your client is unable to hold the 18 million
row result and crashing with out of memory. Nothing you do in the
server or client is going to magic more memory for you, you need to
avoid getting it in the first place.

If you only want to display part of it, do a LIMIT <rows>. Or use a
cursor to page through it.

That said, it would be nice if it returned an error instead of
crashing.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.