Willem Buitendyk <willem@xxxxxxxxx> writes: > The problem was with the following: > FOR current_row IN SELECT * from temp_tags_18_counted > The select from the [temp_tags_18_counted] view is made up of 3 cross > joins. When I simplify and remove the joins everything works. I tried > this with some test data with only a few rows and the joins in place and > it works too. > In the production data table there are about 250K rows. Is it possible > that calls to queries are colliding here or not giving each other enough > time before being whisked around to next call in the FOR loop? No. Please provide a test case instead of speculating. And, again, what is the PG version? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
