[Bugg hash join and parallel worker] - Mailing list pgsql-bugs

SELECT  count(*)  FROM (select anod_siret_decl,anod_mpd,anod_frac

             from dsn_anomalies.dsn_ano_camp_ctr c

                      join dsn_anomalies.dsn_ano_rel_camp darc on c.camp_it = darc.camp_it

                      join dsn_anomalies.dsn_ano_anomalie on darc.ano_it = dsn_ano_anomalie.ano_it

                      join dsn_anomalies.dsn_ano_decl d on c.anod_it = d.anod_it

                      join dsn_anomalies.dsn_ano_statut_anomalie

                           on dsn_anomalies.dsn_ano_statut_anomalie.sta_it =

                              (select dsn_anomalies.dsn_ano_statut_anomalie.sta_it

                               from dsn_anomalies.dsn_ano_statut_anomalie

                               where dsn_anomalies.dsn_ano_statut_anomalie.ano_it =

                                     dsn_anomalies.dsn_ano_anomalie.ano_it

                               order by dsn_anomalies.dsn_ano_statut_anomalie.sta_ts_crea desc

                               limit 1)

             where c.camp_cd_ctx_exec = '7_FLUX_DSNDI'

               and sta_cd_statut = 'DEPOT') a

                join (select anod_siret_decl,camp_dt_mois_ctrl,anod_frac

                      from dsn_anomalies.dsn_ano_camp_ctr c

                               join dsn_anomalies.dsn_ano_decl d

                                    on c.anod_it = d.anod_it

                      where c.camp_cd_ctx_exec = '10_DSNDADI_EXIGIBILITE') b

                     on (a.anod_siret_decl, a.anod_mpd, a.anod_frac) =

                        (b.anod_siret_decl, b.camp_dt_mois_ctrl, b.anod_frac);

ERROR:  invalid DSA memory alloc request size 1811939328

CONTEXT:  parallel worker

enable_parallel_hash=off