| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | <mhromada(at)elas(dot)sk>, <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Bug #715: Too much memory consuming with postmaster |
| Date: | 2002-07-19 13:53:55 |
| Message-ID: | 20020719065234.X82006-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, 19 Jul 2002 pgsql-bugs(at)postgresql(dot)org wrote:
> 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,
...
Is the performance issue on creating the view, selecting from it?
If the latter, what does explain show in the two cases?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-19 13:56:47 | Re: Bug #715: Too much memory consuming with postmaster |
| Previous Message | Bruce Momjian | 2002-07-19 13:49:43 | Re: pg_ctl failure with older Bourne shells (use ${1:+"$@"}) |