P BY the one that causes this OOM (when I removed it, the
query finish ok ) , so I've change the query-plan to avoid the HashAggregate:
telecom=# show enable_hashagg ;
enable_hashagg
off
But the explain still shows:
HashAggregate (cost=19768044.56..20039932.00 rows=27188744 width=152)
Group Key: changelog_change_transaction.changelog_change_transactionid,
changelog_change_transaction.epoch,
changelog_change_transaction.changelog_change_groupid,
changelog_change_transaction.started_at,
changelog_change_transaction.duration_microseconds,
changelog_change_transaction.changed_items, changelog_change_transaction.xmin
Any help or light on this will be really appreciated!
Regards
Jorge Daniel Fernandez
Hi Adam , I've been seeing this same kind of Error in my clusters for a while .
Is this running on postgresql 9.4.8? Because mine was fixed upgrading to 9.4.11
, a bug indeed .
Kind regards
Jorge Daniel Fernandez
From: Adam Sjøgren
Sent: Tu
