Re: Trying to eliminate union and sort

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Trying to eliminate union and sort
Дата
Msg-id 51E086A1.2080504@agliodbs.com
обсуждение исходный текст
Ответ на Trying to eliminate union and sort  (Brian Fehrle <brianf@consistentstate.com>)
Ответы Re: Trying to eliminate union and sort  (Brian Fehrle <brianf@consistentstate.com>)
Список pgsql-performance
> As for the counts on the tables:
> table1      3,653,472
> table2      2,191,314
> table3    25,676,589
>
> I think it's safe to assume right now that any resulting joins are not
> one-to-one

Hmmm?  How is doing a subselect in the SELECT clause even working, then?


--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


В списке pgsql-performance по дате отправления:

Предыдущее
От: Brian Fehrle
Дата:
Сообщение: Re: Trying to eliminate union and sort
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: In progress INSERT wrecks plans on table