Skip site navigation (1) Skip section navigation (2)

Bug #715: Too much memory consuming with postmaster

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #715: Too much memory consuming with postmaster
Date: 2002-07-19 12:22:28
Message-ID: 20020719122228.2D9BC4759C8@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Milan Hromada (mhromada(at)elas(dot)sk) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Too much memory consuming with postmaster

Long Description
Big diffrence in performence between 7.1 and 7.2.1. In 7.2.1 postmaster grows up to 700 MB RAM and more while in 7.1 just up to 8 MB RAM.
7.1 has better response on 1.4 Ghz Athlon 256MB RAM then 7.2.1 on Dual 1GHz Intel Pentium III with 1GB RAM. Postmaster cousumes all resoureces

Sample Code
CREATE VIEW "faksluexport" AS SELECT "zakazkaoprava"."id_zakazka" as idzakazka,
"cisopravaceny"."cena_bezdph" as p_cena,
"cisopravaceny"."cena" as p_cena_c,"cisopravaceny"."kdph" as kdph,
"zakazka"."id_cispobocka" as pobocka, "cispobocka"."stredisko" as stredisko,"cisoprava"."popis" as
+snaz,
"cisdealer"."snaz" as snazo,"cisfakt"."ico" as ico,"cisfakt"."cislo_uctu" as cbu,"zakazka"."cislo" as
+zakazka,"cisbanka"."kod" as skb,"cisvyrobca"."znacka" as znacka,
"zakazka"."id_ciszaruka" as zaruka,
"zakazkauct"."storno" as storno
FROM "cisoprava","zakazkaoprava","cisopravaceny","cisdealer", "zakazka", "cisfakt",
+"zakazkauct","cispobocka","cisbanka","cisvyrobca","cismtop","cismttyp"
WHERE "zakazkaoprava"."id_cisoprava"="cisoprava"."id_cisoprava" AND
"cisoprava"."id_cisoprava"="cismtop"."id_cisoprava"
AND "cismtop"."id_cismtop"="cisopravaceny"."id_cismtop"
AND "cisfakt"."id_cisbanka"="cisbanka"."id_cisbanka"
AND "zakazka"."id_zakazka"="zakazkaoprava"."id_zakazka"
AND "cisopravaceny"."platnost_od"<="zakazka"."d_prijem"
AND ("cisopravaceny"."platnost_do">"zakazka"."d_prijem" OR "cisopravaceny"."platnost_do" IS NULL)
AND "cismtop"."id_cismttyp"="zakazka"."id_cismttyp"
AND "cismtop"."id_cismttyp"="cismttyp"."id_cismttyp"
AND "cisvyrobca"."id_cisvyrobca"="cismttyp"."id_cisvyrobca"
AND "zakazka"."id_zakazka"="zakazkauct"."id_zakazka" AND
+"zakazka"."id_cisdealer"="cisdealer"."id_cisdealer"
AND "cisfakt"."id_cisfakt"="cisdealer"."id_cisfakt" AND "zakazkauct"."d_export"='1'
AND "zakazkauct"."typ_platby"='0'
AND "zakazka"."id_cispobocka"="cispobocka"."id_cispobocka"
ORDER BY idzakazka,p_cena DESC;

No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-07-19 12:27:15
Subject: Bug #716: No index usage for "WHERE a IN ( SELECT ...)"
Previous:From: Ping (No Magic Asia)Date: 2002-07-19 11:16:35
Subject: initdb problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group