On Fri, 19 Jul 2002 pgsql-bugs@postgresql.org wrote:
> Milan Hromada (mhromada@elas.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?