Do Views offer any performance advantage? - Mailing list pgsql-performance

From Robert John Shepherd
Subject Do Views offer any performance advantage?
Date
Msg-id 001f01c30366$93427720$f3b0313e@LAIKA
Whole thread Raw
Responses Re: Do Views offer any performance advantage?
List pgsql-performance
Hi all,

Whilst I often use views for convenience, is there any performance
advantage at all in using a view rather than running the same query
directly on the tables themselves?

Is it quicker to run a full complex query rather than run a much simpler
query on a view? (Hope that makes sense)


Yours Unwhettedly,
Robert John Shepherd.

Editor
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine
http://www.dvd.reviewer.co.uk

For a copy of my Public PGP key, email: pgp@robertsworld.org.uk


pgsql-performance by date:

Previous
From: Will LaShell
Date:
Subject: Re: for help!
Next
From: Richard Huxton
Date:
Subject: Re: [GENERAL] Yet Another (Simple) Case of Index not used