Query runs out of memory

[rokkena]

Hi, I'm working with some VERY large databases and running a join. After a while, I get an out of Memory error because the results in memory grow too big. What are some work arounds? I'm using PostgreSQL.
I've heard of a method that uses fetch and limit, but I can't use an external program to detect when 0 lines are turned.

Many thanks.

 

[feherke]

Hi

What operating system ? If it is Unix or Linux, try to create more swap before that huge query.

Or maybe you can rewrite it as PL/pgSQL stored procedure which to execute more smaller queries.

But is hard to help without knowing more about the query and/or data.

Feherke.

http://rootshell.be/~feherke/