[9.1] unusable for large views

From: "Omar Bettin" <o(dot)bettin(at)informaticaindustriale(dot)it>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: [9.1] unusable for large views
Date: 2011-10-24 08:57:34
Message-ID: 003f01cc922a$fbc58790$f35096b0$@bettin@informaticaindustriale.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I have tried 9.1.1 win64 version and when I am trying to declare a cursor
for a very large view (lot of joins and aggregate functions),

postgres is using around 3GB of memory and the query never returns.

Same proble selecting from the view without cursor.

Same query worked fine from 8.3.3 to 9.0.5.

Should I change some configuration params to have the same behavior as
previous versions?

Tried on Win2008 server R2 64bit 8GB RAM.

also on Win7 64bit 8GB RAM.

default postgresql.conf

Regards,

The view (!)

CREATE OR REPLACE VIEW articoli_rip_ven20110227_view AS

SELECT a.pk_id, a.articolo, a.articolo_f, a.origine, ( SELECT
ditte.attivita

FROM ditte

WHERE ditte.partitario = a.cod_fornit) AS dummy_1, a.descrizion,
a.taglia, a.peso_spec, a.giacenza_colli, a.giacenza, rim.colli AS
rimanenza_colli, rim.quantita AS rimanenza_qta, rimass.colli AS
rimanenza_ass_colli, rimass.quantita AS rimanenza_ass_qta,
COALESCE(b20.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b21.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b22.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b23.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b24.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b25.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b26.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b27.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b28.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b29.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b30.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b31.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b32.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b33.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b34.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b35.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b36.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b37.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b38.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b39.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b40.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b41.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b42.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b43.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b44.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b45.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b46.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b47.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b48.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b49.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b50.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b51.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b52.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b53.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b54.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b55.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b56.quantita, NULL::numeric, 0::numeric)::double precision +
(COALESCE(rim.quantita, NULL::numeric, 0::numeric) +
COALESCE(rimass.quantita, NULL::numeric, 0::numeric))::double precision -
(COALESCE(b1.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b2.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b3.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b4.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b5.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b6.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b7.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b8.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b9.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b10.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b11.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b12.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b13.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b14.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b15.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b16.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b17.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b18.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b19.quantita, NULL::numeric, 0::numeric)::double precision) AS
diff_qta, COALESCE(b1.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b2.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b3.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b4.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b5.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b6.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b7.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b8.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b9.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b10.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b11.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b12.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b13.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b14.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b15.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b16.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b17.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b18.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b19.colli::integer, NULL::integer, 0)::smallint AS sum_colli_cli,
COALESCE(b1.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b2.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b3.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b4.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b5.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b6.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b7.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b8.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b9.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b10.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b11.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b12.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b13.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b14.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b15.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b16.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b17.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b18.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b19.quantita, NULL::numeric, 0::numeric)::double precision AS
sum_qta_cli, COALESCE(b20.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b21.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b22.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b23.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b24.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b25.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b26.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b27.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b28.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b29.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b30.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b31.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b32.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b33.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b34.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b35.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b36.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b37.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b38.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b39.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b40.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b41.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b42.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b43.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b44.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b45.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b46.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b47.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b48.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b49.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b50.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b51.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b52.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b53.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b54.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b55.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b56.colli::integer, NULL::integer, 0)::smallint +
(COALESCE(rim.colli, NULL::bigint, 0::bigint) + COALESCE(rimass.colli,
NULL::bigint, 0::bigint))::smallint AS sum_colli_for, COALESCE(b20.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b21.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b22.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b23.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b24.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b25.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b26.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b27.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b28.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b29.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b30.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b31.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b32.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b33.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b34.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b35.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b36.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b37.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b38.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b39.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b40.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b41.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b42.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b43.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b44.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b45.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b46.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b47.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b48.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b49.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b50.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b51.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b52.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b53.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b54.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b55.quantita,
NULL::numeric, 0::numeric)::double precision + COALESCE(b56.quantita,
NULL::numeric, 0::numeric)::double precision + (COALESCE(rim.quantita,
NULL::numeric, 0::numeric) + COALESCE(rimass.quantita, NULL::numeric,
0::numeric))::double precision AS sum_qta_for, COALESCE(b20.colli::integer,
NULL::integer, 0)::smallint + COALESCE(b21.colli::integer, NULL::integer,
0)::smallint + COALESCE(b22.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b23.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b24.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b25.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b26.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b27.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b28.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b29.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b30.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b31.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b32.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b33.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b34.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b35.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b36.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b37.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b38.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b39.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b40.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b41.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b42.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b43.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b44.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b45.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b46.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b47.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b48.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b49.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b50.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b51.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b52.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b53.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b54.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b55.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b56.colli::integer, NULL::integer, 0)::smallint +
(COALESCE(rim.colli, NULL::bigint, 0::bigint) + COALESCE(rimass.colli,
NULL::bigint, 0::bigint))::smallint - (COALESCE(b1.colli::integer,
NULL::integer, 0)::smallint + COALESCE(b2.colli::integer, NULL::integer,
0)::smallint + COALESCE(b3.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b4.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b5.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b6.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b7.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b8.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b9.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b10.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b11.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b12.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b13.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b14.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b15.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b16.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b17.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b18.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b19.colli::integer, NULL::integer, 0)::smallint) AS diff_colli,
(COALESCE(b1.stato::integer, NULL::integer, 0)::smallint > 0 OR b1.articolo
IS NULL) AND (COALESCE(b2.stato::integer, NULL::integer, 0)::smallint > 0 OR
b2.articolo IS NULL) AND (COALESCE(b3.stato::integer, NULL::integer,
0)::smallint > 0 OR b3.articolo IS NULL) AND (COALESCE(b4.stato::integer,
NULL::integer, 0)::smallint > 0 OR b4.articolo IS NULL) AND
(COALESCE(b5.stato::integer, NULL::integer, 0)::smallint > 0 OR b5.articolo
IS NULL) AND (COALESCE(b6.stato::integer, NULL::integer, 0)::smallint > 0 OR
b6.articolo IS NULL) AND (COALESCE(b7.stato::integer, NULL::integer,
0)::smallint > 0 OR b7.articolo IS NULL) AND (COALESCE(b8.stato::integer,
NULL::integer, 0)::smallint > 0 OR b8.articolo IS NULL) AND
(COALESCE(b9.stato::integer, NULL::integer, 0)::smallint > 0 OR b9.articolo
IS NULL) AND (COALESCE(b10.stato::integer, NULL::integer, 0)::smallint > 0
OR b10.articolo IS NULL) AND (COALESCE(b11.stato::integer, NULL::integer,
0)::smallint > 0 OR b11.articolo IS NULL) AND (COALESCE(b12.stato::integer,
NULL::integer, 0)::smallint > 0 OR b12.articolo IS NULL) AND
(COALESCE(b13.stato::integer, NULL::integer, 0)::smallint > 0 OR
b13.articolo IS NULL) AND (COALESCE(b14.stato::integer, NULL::integer,
0)::smallint > 0 OR b14.articolo IS NULL) AND (COALESCE(b15.stato::integer,
NULL::integer, 0)::smallint > 0 OR b15.articolo IS NULL) AND
(COALESCE(b16.stato::integer, NULL::integer, 0)::smallint > 0 OR
b16.articolo IS NULL) AND (COALESCE(b17.stato::integer, NULL::integer,
0)::smallint > 0 OR b17.articolo IS NULL) AND (COALESCE(b18.stato::integer,
NULL::integer, 0)::smallint > 0 OR b18.articolo IS NULL) AND
(COALESCE(b19.stato::integer, NULL::integer, 0)::smallint > 0 OR
b19.articolo IS NULL) AS chk_cli, (COALESCE(b20.stato, NULL::integer,
0)::smallint > 0 OR b20.articolo IS NULL) AND (COALESCE(b21.stato,
NULL::integer, 0)::smallint > 0 OR b21.articolo IS NULL) AND
(COALESCE(b22.stato, NULL::integer, 0)::smallint > 0 OR b22.articolo IS
NULL) AND (COALESCE(b23.stato, NULL::integer, 0)::smallint > 0 OR
b23.articolo IS NULL) AND (COALESCE(b24.stato, NULL::integer, 0)::smallint >
0 OR b24.articolo IS NULL) AND (COALESCE(b25.stato, NULL::integer,
0)::smallint > 0 OR b25.articolo IS NULL) AND (COALESCE(b26.stato,
NULL::integer, 0)::smallint > 0 OR b26.articolo IS NULL) AND
(COALESCE(b27.stato, NULL::integer, 0)::smallint > 0 OR b27.articolo IS
NULL) AND (COALESCE(b28.stato, NULL::integer, 0)::smallint > 0 OR
b28.articolo IS NULL) AND (COALESCE(b29.stato, NULL::integer, 0)::smallint >
0 OR b29.articolo IS NULL) AND (COALESCE(b30.stato, NULL::integer,
0)::smallint > 0 OR b30.articolo IS NULL) AND (COALESCE(b31.stato,
NULL::integer, 0)::smallint > 0 OR b31.articolo IS NULL) AND
(COALESCE(b32.stato, NULL::integer, 0)::smallint > 0 OR b32.articolo IS
NULL) AND (COALESCE(b33.stato, NULL::integer, 0)::smallint > 0 OR
b33.articolo IS NULL) AND (COALESCE(b34.stato, NULL::integer, 0)::smallint >
0 OR b34.articolo IS NULL) AND (COALESCE(b35.stato, NULL::integer,
0)::smallint > 0 OR b35.articolo IS NULL) AND (COALESCE(b36.stato,
NULL::integer, 0)::smallint > 0 OR b36.articolo IS NULL) AND
(COALESCE(b37.stato, NULL::integer, 0)::smallint > 0 OR b37.articolo IS
NULL) AND (COALESCE(b38.stato, NULL::integer, 0)::smallint > 0 OR
b38.articolo IS NULL) AND (COALESCE(b39.stato, NULL::integer, 0)::smallint >
0 OR b39.articolo IS NULL) AND (COALESCE(b40.stato, NULL::integer,
0)::smallint > 0 OR b40.articolo IS NULL) AND (COALESCE(b41.stato,
NULL::integer, 0)::smallint > 0 OR b41.articolo IS NULL) AND
(COALESCE(b42.stato, NULL::integer, 0)::smallint > 0 OR b42.articolo IS
NULL) AND (COALESCE(b43.stato, NULL::integer, 0)::smallint > 0 OR
b43.articolo IS NULL) AND (COALESCE(b44.stato, NULL::integer, 0)::smallint >
0 OR b44.articolo IS NULL) AND (COALESCE(b45.stato, NULL::integer,
0)::smallint > 0 OR b45.articolo IS NULL) AND (COALESCE(b46.stato,
NULL::integer, 0)::smallint > 0 OR b46.articolo IS NULL) AND
(COALESCE(b47.stato, NULL::integer, 0)::smallint > 0 OR b47.articolo IS
NULL) AND (COALESCE(b48.stato, NULL::integer, 0)::smallint > 0 OR
b48.articolo IS NULL) AND (COALESCE(b49.stato, NULL::integer, 0)::smallint >
0 OR b49.articolo IS NULL) AND (COALESCE(b50.stato, NULL::integer,
0)::smallint > 0 OR b50.articolo IS NULL) AND (COALESCE(b51.stato,
NULL::integer, 0)::smallint > 0 OR b51.articolo IS NULL) AND
(COALESCE(b52.stato, NULL::integer, 0)::smallint > 0 OR b52.articolo IS
NULL) AND (COALESCE(b53.stato, NULL::integer, 0)::smallint > 0 OR
b53.articolo IS NULL) AND (COALESCE(b54.stato, NULL::integer, 0)::smallint >
0 OR b54.articolo IS NULL) AND (COALESCE(b55.stato, NULL::integer,
0)::smallint > 0 OR b55.articolo IS NULL) AND (COALESCE(b56.stato,
NULL::integer, 0)::smallint > 0 OR b56.articolo IS NULL) AS chk_for,
b1.colli AS t_colli7717cli, b1.quantita AS t_qta7717cli, b1.stato AS
st7717cli, b1.eti_ok AS ok7717cli, b2.colli AS t_colli7705cli, b2.quantita
AS t_qta7705cli, b2.stato AS st7705cli, b2.eti_ok AS ok7705cli, b3.colli AS
t_colli7715cli, b3.quantita AS t_qta7715cli, b3.stato AS st7715cli,
b3.eti_ok AS ok7715cli, b4.colli AS t_colli7704cli, b4.quantita AS
t_qta7704cli, b4.stato AS st7704cli, b4.eti_ok AS ok7704cli, b5.colli AS
t_colli7714cli, b5.quantita AS t_qta7714cli, b5.stato AS st7714cli,
b5.eti_ok AS ok7714cli, b6.colli AS t_colli7718cli, b6.quantita AS
t_qta7718cli, b6.stato AS st7718cli, b6.eti_ok AS ok7718cli, b7.colli AS
t_colli7713cli, b7.quantita AS t_qta7713cli, b7.stato AS st7713cli,
b7.eti_ok AS ok7713cli, b8.colli AS t_colli7708cli, b8.quantita AS
t_qta7708cli, b8.stato AS st7708cli, b8.eti_ok AS ok7708cli, b9.colli AS
t_colli7719cli, b9.quantita AS t_qta7719cli, b9.stato AS st7719cli,
b9.eti_ok AS ok7719cli, b10.colli AS t_colli7709cli, b10.quantita AS
t_qta7709cli, b10.stato AS st7709cli, b10.eti_ok AS ok7709cli, b11.colli AS
t_colli7722cli, b11.quantita AS t_qta7722cli, b11.stato AS st7722cli,
b11.eti_ok AS ok7722cli, b12.colli AS t_colli7706cli, b12.quantita AS
t_qta7706cli, b12.stato AS st7706cli, b12.eti_ok AS ok7706cli, b13.colli AS
t_colli7716cli, b13.quantita AS t_qta7716cli, b13.stato AS st7716cli,
b13.eti_ok AS ok7716cli, b14.colli AS t_colli7721cli, b14.quantita AS
t_qta7721cli, b14.stato AS st7721cli, b14.eti_ok AS ok7721cli, b15.colli AS
t_colli7707cli, b15.quantita AS t_qta7707cli, b15.stato AS st7707cli,
b15.eti_ok AS ok7707cli, b16.colli AS t_colli7712cli, b16.quantita AS
t_qta7712cli, b16.stato AS st7712cli, b16.eti_ok AS ok7712cli, b17.colli AS
t_colli7711cli, b17.quantita AS t_qta7711cli, b17.stato AS st7711cli,
b17.eti_ok AS ok7711cli, b18.colli AS t_colli7710cli, b18.quantita AS
t_qta7710cli, b18.stato AS st7710cli, b18.eti_ok AS ok7710cli, b19.colli AS
t_colli7720cli, b19.quantita AS t_qta7720cli, b19.stato AS st7720cli,
b19.eti_ok AS ok7720cli, b20.colli AS t_colli18499for, b20.quantita AS
t_qta18499for, b20.stato AS st18499for, b21.colli AS t_colli18502for,
b21.quantita AS t_qta18502for, b21.stato AS st18502for, b22.colli AS
t_colli18469for, b22.quantita AS t_qta18469for, b22.stato AS st18469for,
b23.colli AS t_colli18475for, b23.quantita AS t_qta18475for, b23.stato AS
st18475for, b24.colli AS t_colli18472for, b24.quantita AS t_qta18472for,
b24.stato AS st18472for, b25.colli AS t_colli18462for, b25.quantita AS
t_qta18462for, b25.stato AS st18462for, b26.colli AS t_colli18479for,
b26.quantita AS t_qta18479for, b26.stato AS st18479for, b27.colli AS
t_colli18505for, b27.quantita AS t_qta18505for, b27.stato AS st18505for,
b28.colli AS t_colli18470for, b28.quantita AS t_qta18470for, b28.stato AS
st18470for, b29.colli AS t_colli18477for, b29.quantita AS t_qta18477for,
b29.stato AS st18477for, b30.colli AS t_colli18465for, b30.quantita AS
t_qta18465for, b30.stato AS st18465for, b31.colli AS t_colli18453for,
b31.quantita AS t_qta18453for, b31.stato AS st18453for, b32.colli AS
t_colli18457for, b32.quantita AS t_qta18457for, b32.stato AS st18457for,
b33.colli AS t_colli18450for, b33.quantita AS t_qta18450for, b33.stato AS
st18450for, b34.colli AS t_colli18451for, b34.quantita AS t_qta18451for,
b34.stato AS st18451for, b35.colli AS t_colli18454for, b35.quantita AS
t_qta18454for, b35.stato AS st18454for, b36.colli AS t_colli18456for,
b36.quantita AS t_qta18456for, b36.stato AS st18456for, b37.colli AS
t_colli18455for, b37.quantita AS t_qta18455for, b37.stato AS st18455for,
b38.colli AS t_colli18458for, b38.quantita AS t_qta18458for, b38.stato AS
st18458for, b39.colli AS t_colli18501for, b39.quantita AS t_qta18501for,
b39.stato AS st18501for, b40.colli AS t_colli18504for, b40.quantita AS
t_qta18504for, b40.stato AS st18504for, b41.colli AS t_colli18471for,
b41.quantita AS t_qta18471for, b41.stato AS st18471for, b42.colli AS
t_colli18500for, b42.quantita AS t_qta18500for, b42.stato AS st18500for,
b43.colli AS t_colli18503for, b43.quantita AS t_qta18503for, b43.stato AS
st18503for, b44.colli AS t_colli18461for, b44.quantita AS t_qta18461for,
b44.stato AS st18461for, b45.colli AS t_colli18478for, b45.quantita AS
t_qta18478for, b45.stato AS st18478for, b46.colli AS t_colli18467for,
b46.quantita AS t_qta18467for, b46.stato AS st18467for, b47.colli AS
t_colli18474for, b47.quantita AS t_qta18474for, b47.stato AS st18474for,
b48.colli AS t_colli18459for, b48.quantita AS t_qta18459for, b48.stato AS
st18459for, b49.colli AS t_colli18460for, b49.quantita AS t_qta18460for,
b49.stato AS st18460for, b50.colli AS t_colli18464for, b50.quantita AS
t_qta18464for, b50.stato AS st18464for, b51.colli AS t_colli18480for,
b51.quantita AS t_qta18480for, b51.stato AS st18480for, b52.colli AS
t_colli18506for, b52.quantita AS t_qta18506for, b52.stato AS st18506for,
b53.colli AS t_colli18452for, b53.quantita AS t_qta18452for, b53.stato AS
st18452for, b54.colli AS t_colli18463for, b54.quantita AS t_qta18463for,
b54.stato AS st18463for, b55.colli AS t_colli18466for, b55.quantita AS
t_qta18466for, b55.stato AS st18466for, b56.colli AS t_colli18473for,
b56.quantita AS t_qta18473for, b56.stato AS st18473for

FROM articoli a

LEFT JOIN articoli_rim_rip_ven20110227_view rim ON rim.articolo =
a.articolo

LEFT JOIN articoli_rim_ass_rip_ven20110227_view rimass ON rimass.articolo
= a.articolo

LEFT JOIN bolrighe b1 ON b1.numero = 7717 AND b1.articolo = a.articolo

LEFT JOIN bolrighe b2 ON b2.numero = 7705 AND b2.articolo = a.articolo

LEFT JOIN bolrighe b3 ON b3.numero = 7715 AND b3.articolo = a.articolo

LEFT JOIN bolrighe b4 ON b4.numero = 7704 AND b4.articolo = a.articolo

LEFT JOIN bolrighe b5 ON b5.numero = 7714 AND b5.articolo = a.articolo

LEFT JOIN bolrighe b6 ON b6.numero = 7718 AND b6.articolo = a.articolo

LEFT JOIN bolrighe b7 ON b7.numero = 7713 AND b7.articolo = a.articolo

LEFT JOIN bolrighe b8 ON b8.numero = 7708 AND b8.articolo = a.articolo

LEFT JOIN bolrighe b9 ON b9.numero = 7719 AND b9.articolo = a.articolo

LEFT JOIN bolrighe b10 ON b10.numero = 7709 AND b10.articolo = a.articolo

LEFT JOIN bolrighe b11 ON b11.numero = 7722 AND b11.articolo = a.articolo

LEFT JOIN bolrighe b12 ON b12.numero = 7706 AND b12.articolo = a.articolo

LEFT JOIN bolrighe b13 ON b13.numero = 7716 AND b13.articolo = a.articolo

LEFT JOIN bolrighe b14 ON b14.numero = 7721 AND b14.articolo = a.articolo

LEFT JOIN bolrighe b15 ON b15.numero = 7707 AND b15.articolo = a.articolo

LEFT JOIN bolrighe b16 ON b16.numero = 7712 AND b16.articolo = a.articolo

LEFT JOIN bolrighe b17 ON b17.numero = 7711 AND b17.articolo = a.articolo

LEFT JOIN bolrighe b18 ON b18.numero = 7710 AND b18.articolo = a.articolo

LEFT JOIN bolrighe b19 ON b19.numero = 7720 AND b19.articolo = a.articolo

LEFT JOIN magmodet b20 ON b20.numero = 18499 AND b20.articolo =
a.articolo

LEFT JOIN magmodet b21 ON b21.numero = 18502 AND b21.articolo =
a.articolo

LEFT JOIN magmodet b22 ON b22.numero = 18469 AND b22.articolo =
a.articolo

LEFT JOIN magmodet b23 ON b23.numero = 18475 AND b23.articolo =
a.articolo

LEFT JOIN magmodet b24 ON b24.numero = 18472 AND b24.articolo =
a.articolo

LEFT JOIN magmodet b25 ON b25.numero = 18462 AND b25.articolo =
a.articolo

LEFT JOIN magmodet b26 ON b26.numero = 18479 AND b26.articolo =
a.articolo

LEFT JOIN magmodet b27 ON b27.numero = 18505 AND b27.articolo =
a.articolo

LEFT JOIN magmodet b28 ON b28.numero = 18470 AND b28.articolo =
a.articolo

LEFT JOIN magmodet b29 ON b29.numero = 18477 AND b29.articolo =
a.articolo

LEFT JOIN magmodet b30 ON b30.numero = 18465 AND b30.articolo =
a.articolo

LEFT JOIN magmodet b31 ON b31.numero = 18453 AND b31.articolo =
a.articolo

LEFT JOIN magmodet b32 ON b32.numero = 18457 AND b32.articolo =
a.articolo

LEFT JOIN magmodet b33 ON b33.numero = 18450 AND b33.articolo =
a.articolo

LEFT JOIN magmodet b34 ON b34.numero = 18451 AND b34.articolo =
a.articolo

LEFT JOIN magmodet b35 ON b35.numero = 18454 AND b35.articolo =
a.articolo

LEFT JOIN magmodet b36 ON b36.numero = 18456 AND b36.articolo =
a.articolo

LEFT JOIN magmodet b37 ON b37.numero = 18455 AND b37.articolo =
a.articolo

LEFT JOIN magmodet b38 ON b38.numero = 18458 AND b38.articolo =
a.articolo

LEFT JOIN magmodet b39 ON b39.numero = 18501 AND b39.articolo =
a.articolo

LEFT JOIN magmodet b40 ON b40.numero = 18504 AND b40.articolo =
a.articolo

LEFT JOIN magmodet b41 ON b41.numero = 18471 AND b41.articolo =
a.articolo

LEFT JOIN magmodet b42 ON b42.numero = 18500 AND b42.articolo =
a.articolo

LEFT JOIN magmodet b43 ON b43.numero = 18503 AND b43.articolo =
a.articolo

LEFT JOIN magmodet b44 ON b44.numero = 18461 AND b44.articolo =
a.articolo

LEFT JOIN magmodet b45 ON b45.numero = 18478 AND b45.articolo =
a.articolo

LEFT JOIN magmodet b46 ON b46.numero = 18467 AND b46.articolo =
a.articolo

LEFT JOIN magmodet b47 ON b47.numero = 18474 AND b47.articolo =
a.articolo

LEFT JOIN magmodet b48 ON b48.numero = 18459 AND b48.articolo =
a.articolo

LEFT JOIN magmodet b49 ON b49.numero = 18460 AND b49.articolo =
a.articolo

LEFT JOIN magmodet b50 ON b50.numero = 18464 AND b50.articolo =
a.articolo

LEFT JOIN magmodet b51 ON b51.numero = 18480 AND b51.articolo =
a.articolo

LEFT JOIN magmodet b52 ON b52.numero = 18506 AND b52.articolo =
a.articolo

LEFT JOIN magmodet b53 ON b53.numero = 18452 AND b53.articolo =
a.articolo

LEFT JOIN magmodet b54 ON b54.numero = 18463 AND b54.articolo =
a.articolo

LEFT JOIN magmodet b55 ON b55.numero = 18466 AND b55.articolo =
a.articolo

LEFT JOIN magmodet b56 ON b56.numero = 18473 AND b56.articolo =
a.articolo;

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2011-10-24 10:13:26 Re: [9.1] unusable for large views
Previous Message Thom Brown 2011-10-24 08:13:23 Re: Silent failure with invalid hba_file setting