Re: Out of memory on SELECT (from sort?) in 8.3

Matt Magoffin wrote:
> I have a SELECT query that causes an out-of-memory error on my production
> Postgres 8.3 server. I believe the culprit is from the sort in the query,
> but its running out on queries that return 300,000 results which I didn't
> think was very large.

It's not the sort.  There's a memory leak in the system somewhere.  Can
you post a reproducible test case?  (If you can do it in the next couple
of days, there's a chance the fix will make it to 8.3.4).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support