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