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.

 

[RiverGuy]

You need to post your question in the Postgre forum, as this question would be too specific to the individual DBMS.

forum699

 

[SQLSister]

Also, it is almost impossible to determine the casue of an issue like this without a look at the code that is running. So please post the code when you go to the forum you need.

"NOTHING is more important in a database than integrity." ESquared