On Sun, May 22, 2016 at 23:38:43 -0700, John R Pierce <pie...@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.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
