Re: Pushing LIMIT into sub-queries of a UNION ALL? - Mailing list pgsql-performance

From Robert Klemme
Subject Re: Pushing LIMIT into sub-queries of a UNION ALL?
Date
Msg-id BANLkTimYit+UyPjN0TJKenB7iMx5+uojGQ@mail.gmail.com
Whole thread Raw
In response to Re: Pushing LIMIT into sub-queries of a UNION ALL?  (Dave Johansen <davejohansen@gmail.com>)
List pgsql-performance
On Mon, May 23, 2011 at 5:54 PM, Dave Johansen <davejohansen@gmail.com> 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 _three_ instances of this
posting (first on May 18th).

> Also, the database I posted this about does not have internet access and so
> I'm working on getting it moved over to a machine that does or getting it
> the info onto a machine where I can post the pertinent information about the
> schema and explain outputs.

Great!

Cheers

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Performance degradation of inserts when database size grows
Next
From: Josh Berkus
Date:
Subject: Re: Pushing LIMIT into sub-queries of a UNION ALL?