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

Re: performance benefit with views?

From: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
To: Horst Herb <hherb(at)malleenet(dot)net(dot)au>
Cc: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: performance benefit with views?
Date: 2001-11-19 23:42:36
Message-ID: 1006213356.16223.63.camel@kant.mcmillan.net.nz (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, 2001-11-19 at 15:02, Horst Herb wrote:
> Is there any performance benefit in Postgres by implementing a complex 
> nested query as a view?

No.


> If so, is there anything special I should pay atttention to to get the 
> maximum benefit?

No.

In fact there can be a performance impact by using views, particularly
nested views (although this might be fixed in the most recent releases).

<speculation>
At some point there is a 'fabled' query tree redesign coming, and this
may manage to hold statistics for views, which might enable the planner
to work more efficiently on views for which such statistics had been
collected.
</speculation>

Regards,
					Andrew.
-- 
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2001-11-20 06:05:15
Subject: Re: Triggers & Compiled C Language Functions
Previous:From: Tom LaneDate: 2001-11-19 20:46:47
Subject: Re: 7.1.3 compilation failure (libpq or aync?)

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