Postgres Pro
Downloads
Home   >   mailing lists

Re: Views with unions - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Views with unions
Date
Msg-id 200302151954.33740.josh@agliodbs.com
Whole thread Raw
In response to Views with unions  (Mariusz Czułada <manieq@idea.net.pl>)
Responses Re: Views with unions  (Mariusz Czułada <manieq@idea.net.pl>)
Re: Views with unions  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-performance
Tree view 
Mariusz,

> While testing multi-select views I found some problems. Here are details. I
> have 3 tables and I created a view on them:

What version of PostgreSQL are you using?   UNION views optimized extremely
poorly through 7.2.4; things have been improved in 7.3

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Mariusz Czułada
Date:
Subject: Views with unions
Next
From: Mariusz Czułada
Date:
Subject: Re: Views with unions