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 по дате отправления:

Предыдущее
От: ITAGAKI Takahiro
Дата:
Сообщение: Comments to Synchronous replication patch v3
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Explicitly bind gettext() to the UTF8 locale when in use.