Postgres Pro
Downloads
Home   >   mailing lists

are views typically any faster/slower than equivilent joins? - Mailing list pgsql-performance

From Brian Tarbox
Subject are views typically any faster/slower than equivilent joins?
Date
Msg-id 001801c327e9$3c01a5b0$01000001@trouble
Whole thread Raw
In response to Re: why Sequencial Scan when selecting on primary key of table?  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: are views typically any faster/slower than equivilent joins?  (Rod Taylor <rbt@rbt.ca>)
Re: are views typically any faster/slower than equivilent joins?  (Rod Taylor <rbt@rbt.ca>)
List pgsql-performance
Tree view 
I am working with a highly normalized database.  Most of my meaningful
queries involve joins from a primary table to 4-6 secondary tables.

Would my query performance be significantly faster/slower using a View as
opposed to a prepared query using join?

(Assume all join fields are ints, say 10,000 records in main table and a few
dozen records in each of the secondary tables).

Thank you.

Brian Tarbox

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: why Sequencial Scan when selecting on primary key of table?
Next
From: Rod Taylor
Date:
Subject: Re: are views typically any faster/slower than equivilent joins?