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
