Postgres Pro
Downloads
Home   >   mailing lists

Re: Oddity with view - Mailing list pgsql-performance

From Tom Lane
Subject Re: Oddity with view
Date
Msg-id 3128.1226322412@sss.pgh.pa.us
Whole thread Raw
In response to Oddity with view  (Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>)
Responses Re: Oddity with view
List pgsql-performance
Tree view 
"Jim 'Decibel!' Nasby" <jnasby@cashnetusa.com> writes:
> loan_tasks effectively does SELECT * FROM loan_tasks_committed UNION
> ALL SELECT * FROM loan_tasks_pending;.

You seem to have neglected to mention a join or two.

            regards, tom lane

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Improve Seq scan performance
Next
From: Lutischán Ferenc
Date:
Subject: Re: Improve Seq scan performance