[PERFORM] Views With Unions

2003-07-31 Thread Christopher Browne
This is stepping back quite a while; let me point people to the thread of 2003-02 where Mariusz Czu\x{0142}ada [EMAIL PROTECTED] was looking for a way of optimizing a VIEW that was a UNION. http://archives.postgresql.org/pgsql-performance/2003-02/msg00095.php The subject has come up a few times

Re: [PERFORM] Views With Unions

2003-07-31 Thread Rajesh Kumar Mallah
Stephan Szabo wrote: On Thu, 31 Jul 2003, Christopher Browne wrote: select * from log_table where request_time between 'june 11 2003' and 'june 12 2003'; returns a plan: Subquery Scan log_table (cost=0.00..10950.26 rows=177126 width=314) -