Re: view and performance

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Wei Weng" <wweng(at)kencast(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: view and performance
Date: 2001-07-07 11:25:34
Message-ID: 007a01c106d7$8b57b1c0$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

From: "Wei Weng" <wweng(at)kencast(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message John Hasler 2001-07-07 12:27:39 Re: Is function atomic?
Previous Message Richard Huxton 2001-07-07 11:21:32 Re: Is function atomic?