Re: [PERFORM] Pushing LIMIT into sub-queries of a UNION ALL?

2011-05-23 Thread Josh Berkus
On 5/23/11 8:54 AM, Dave Johansen wrote: > I apologize for the multiple posts. I sent this email right after joining > the list and after it hadn't shown up a day later I figured that it had been > lost or something and sent the other one. List moderation took a holiday while all of us were at pgC

Re: [PERFORM] Pushing LIMIT into sub-queries of a UNION ALL?

2011-05-23 Thread Robert Klemme
On Mon, May 23, 2011 at 5:54 PM, Dave Johansen wrote: > I apologize for the multiple posts. I sent this email right after joining > the list and after it hadn't shown up a day later I figured that it had been > lost or something and sent the other one. Sorry for the nitpicking but I even see _thr

Re: [PERFORM] Pushing LIMIT into sub-queries of a UNION ALL

2011-05-23 Thread Robert Haas
On Mon, May 16, 2011 at 3:38 PM, Dave Johansen wrote: > I am using Postgres 8.3 and I have an issue very closely related to the one > described here: > http://archives.postgresql.org/pgsql-general/2005-06/msg00488.php > > Basically, I have a VIEW which is a UNION ALL of two tables but when I do a

Re: [PERFORM] Pushing LIMIT into sub-queries of a UNION ALL?

2011-05-23 Thread Dave Johansen
I apologize for the multiple posts. I sent this email right after joining the list and after it hadn't shown up a day later I figured that it had been lost or something and sent the other one. Also, the database I posted this about does not have internet access and so I'm working on getting it mov

Re: [PERFORM] Pushing LIMIT into sub-queries of a UNION ALL?

2011-05-22 Thread Robert Klemme
Dave, how often do you want to repeat that posting? What about instead replying to the answers you got so far? Cheers robert On Tue, May 17, 2011 at 5:31 PM, Dave Johansen wrote: > I am using Postgres 8.3 and I have an issue very closely related to the one > described here: > http://archives

[PERFORM] Pushing LIMIT into sub-queries of a UNION ALL?

2011-05-21 Thread Dave Johansen
I am using Postgres 8.3 and I have an issue very closely related to the one described here: http://archives.postgresql.org/pgsql-general/2005-06/msg00488.php Basically, I have a VIEW which is a UNION ALL of two tables but when I do a select on the view using a LIMIT, it scans the entire tables and

[PERFORM] Pushing LIMIT into sub-queries of a UNION ALL

2011-05-21 Thread Dave Johansen
I am using Postgres 8.3 and I have an issue very closely related to the one described here: http://archives.postgresql.org/pgsql-general/2005-06/msg00488.php Basically, I have a VIEW which is a UNION ALL of two tables but when I do a select on the view using a LIMIT, it scans the entire tables and