Re: split partitioned table across several postgres servers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: split partitioned table across several postgres servers
Дата
Msg-id 9163.1140187745@sss.pgh.pa.us
обсуждение исходный текст
Ответ на split partitioned table across several postgres servers  (martial.bizel@free.fr)
Ответы Re: split partitioned table across several postgres servers  (martial.bizel@free.fr)
Список pgsql-performance
martial.bizel@free.fr writes:
> In fact, I don't know how to have explain plan of remote node.

You send it an EXPLAIN.

You can *not* use a view defined as you suggest if you want decent
performance --- the dblink functions will fetch the entire table
contents and the filtering will be done locally.  You'll need to
pass the WHERE conditions over to the remote servers, which more
or less means that you have to give them to the dblink functions
as text.

            regards, tom lane

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: [HACKERS] qsort again (was Re: Strange Create
Следующее
От: martial.bizel@free.fr
Дата:
Сообщение: Re: split partitioned table across several postgres servers