Re: [SQL] Views and query planner

2006-06-30 Thread Markus Schaber
Hi, Mario, Mario Splivalo wrote: >>> Is postgres going to make one query plan, or each view has it own >>> query >>> plan? >> Have you taken a look at the EXPLAIN ANALYZE output of the queries? >> You can see exactly which plan PostgreSQL will use. > > So, the performance will be the same if

Re: [SQL] Views and query planner

2006-06-30 Thread Mario Splivalo
On Fri, 2006-06-30 at 21:47 +0900, Michael Glaesemann wrote: > On Jun 30, 2006, at 21:35 , Mario Splivalo wrote: > > > Is postgres going to make one query plan, or each view has it own > > query > > plan? > > Have you taken a look at the EXPLAIN ANALYZE output of the queries? > You can see ex

Re: [SQL] Views and query planner

2006-06-30 Thread Michael Glaesemann
On Jun 30, 2006, at 21:35 , Mario Splivalo wrote: Is postgres going to make one query plan, or each view has it own query plan? Have you taken a look at the EXPLAIN ANALYZE output of the queries? You can see exactly which plan PostgreSQL will use. Michael Glaesemann grzm seespotcode net