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

Поиск
Список
Период
Сортировка
От Robert Klemme
Тема Re: Pushing LIMIT into sub-queries of a UNION ALL?
Дата
Msg-id BANLkTimYit+UyPjN0TJKenB7iMx5+uojGQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pushing LIMIT into sub-queries of a UNION ALL?  (Dave Johansen <davejohansen@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Performance degradation of inserts when database size grows
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Pushing LIMIT into sub-queries of a UNION ALL?