Re: huge query tree cost too much time to copyObject()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: huge query tree cost too much time to copyObject()
Дата
Msg-id 9360.1227581536@sss.pgh.pa.us
обсуждение исходный текст
Ответ на huge query tree cost too much time to copyObject()  ("Tao Ma" <feng_eden@163.com>)
Список pgsql-hackers
"Tao Ma" <feng_eden@163.com> writes:
> recently, I wrote a really complex SELECT statement which consists of about 
> 20 relations using NATURAL JOIN method and every single relation consists 50 
> columns. It looks like:

Maybe you should rethink your schema design...

> It seems Postgres cost lots of time to copyObject().

You're completely wasting your time to optimize *that*.
        regards, tom lane


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