I am asking the prev. question because there is no change in the query plan (as far as I see) but the mem usage decreases from 258M to 16M.
Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:I have the following problem. A week ago we've migrated from PGv7.2.3 to 7.4.6. There were a lot of things in the apps to chenge but we made them. But one query doesn't want to run. In the old PGv7.2.3 it passes for 10 min. In the new one it gaves: DBD::Pg::st execute failed: ERROR: out of memoryDoes setting enable_hashagg to OFF fix it?regards, tom lane
- Re: [PERFORM] Performance problem from migrating betwe... Kaloyan Iliev Iliev
- Re: [PERFORM] Performance problem from migrating ... Tom Lane