Re: Postgresql-fdw - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Postgresql-fdw
Date
Msg-id 20160523142729.GA2672@wolff.to
Whole thread Raw
In response to Re: Postgresql-fdw  (John R Pierce <pierce@hogranch.com>)
Responses Re: Postgresql-fdw
List 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 by date:

Previous
From: Marc Mamin
Date:
Subject: Re: revert function for to_json ?
Next
From: Andrej Vanek
Date:
Subject: Re: pg_basebackup: return value 1: reason?