From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | John Taylor <postgres(at)jtresponse(dot)co(dot)uk> |
Cc: | "PgSQL Novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How efficient are Views |
Date: | 2002-06-12 15:31:49 |
Message-ID: | 10056.1023895909@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
John Taylor <postgres(at)jtresponse(dot)co(dot)uk> writes:
> I'm thinking about using a view for my application.
> However, I'm wondering about how efficient it will be once I have a
> large amount of data loaded.
Views are effectively just query macros --- Postgres doesn't have any
notion of pre-materialized views.
Whether this will be efficient or not depends very much on what the
intended view is and how you use it.
> Whould it maybe be faster to have a seperate table alongside the base
> data, and generate it via a trigger or stored procedure ?
You could do that, and in some cases it'd be helpful; in other cases
it'd be a big loss. Without any details on your scenario, we really
can't say more than that. What's the proposed view? How often will
you access the view as compared to modifying the underlying table?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-06-12 15:36:30 | Re: Optimising inside transactions |
Previous Message | Henshall, Stuart - WCP | 2002-06-12 15:24:40 | Re: Optimising inside transactions |