Re: Postgresql-fdw

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql-fdw
Date: 2016-05-23 14:27:29
Message-ID: 20160523142729.GA2672@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, May 22, 2016 at 23:38:43 -0700,
John R Pierce <pierce(at)hogranch(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Vanek 2016-05-23 16:04:52 Re: pg_basebackup: return value 1: reason?
Previous Message Marc Mamin 2016-05-23 14:22:18 Re: revert function for to_json ?