Re: view and performance - Mailing list pgsql-sql

From Richard Huxton
Subject Re: view and performance
Date
Msg-id 007a01c106d7$8b57b1c0$1001a8c0@archonet.com
Whole thread Raw
In response to view and performance  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
From: "Wei Weng" <wweng@kencast.com>

> Is there any gain on performance if you choose to create a view over a
> very complex query instead of running the query itself directly?

I *believe* views are pre-parsed so you gain that time. Can't believe you'd
notice much difference either way unless the query was very fast to execute.

- Richard Huxton



pgsql-sql by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: Is function atomic?
Next
From: John Hasler
Date:
Subject: Re: Is function atomic?