With a heavy query, when line number results raise over 600k query hangs with
out of memory.
Here is the explain analyze:
[...]
Work_mem is.512mb, shared buffers 3084mb and system Ram 10Gb. Postgres version
is 8.4.8 and for some months i cannot upgrade.
Is there a way to solve the problem?
H
Hello,
With a heavy query, when line number results raise over 600k query hangs with
out of memory.
Here is the explain analyze:
CTE Scan on lista (cost=25066.66..47721.23 rows=3678 width=260)
CTE lista
-> Unique (cost=24956.32..25066.66 rows=3678 width=512)
-> Sort (