Re: Postgresql-fdw

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Postgresql-fdw
Дата
Msg-id 20160523142729.GA2672@wolff.to
обсуждение исходный текст
Ответ на Re: Postgresql-fdw  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Postgresql-fdw  ("Rader, David" <davidr@openscg.com>)
Список pgsql-general
On Sun, May 22, 2016 at 23:38:43 -0700,
  John R Pierce <pierce@hogranch.com> wrote:
>
>If you want to use postgres to query this data efficiently, you really
>should import this data into postgres tables, properly indexed for the
>sorts of queries you wish to do.

And it isn't that hard to script this kind of thing. Postgres' copy command
makes it easy to read csv files. You could trigger the scripts by hand (or
as part of the script that runs the queries) just before running queries, run
them scheduled at what are normally good times to pick up updates or trigger
off file changes.


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

Предыдущее
От: Marc Mamin
Дата:
Сообщение: Re: revert function for to_json ?
Следующее
От: Andrej Vanek
Дата:
Сообщение: Re: pg_basebackup: return value 1: reason?