From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql-fdw |
Date: | 2016-05-23 06:38:43 |
Message-ID: | 42661b23-91a1-4ede-4542-58b279535b8f@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5/22/2016 10:52 PM, aluka raju wrote:
> I have data storage in flat files (structured and unstructured) . I
> want to run sql queries on that , so i am looking in to postgresql how
> to use fdw on the data that i have. I want to prepare an api for
> running sql queries for the data in files,so i am trying to have
> separate postgresql engine and write an wrappper for connecting the
> data that are in files.
>
> Help me out how can i proceed.
>
I'm not sure what you're expecting postgres to do for you here... Flat
unstructured files have to be read sequentially to do /anything/.
even a simple 'select * from someflattable where id=115', it will have
to read the whole file to find any and all records with id=115.
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.
--
john r pierce, recycling bits in santa cruz
From | Date | Subject | |
---|---|---|---|
Next Message | aluka raju | 2016-05-23 10:54:01 | postgresql embedded mode |
Previous Message | Arthur Silva | 2016-05-23 06:37:38 | Re: Postgresql-fdw |