Re: Postgresql-fdw

John R Pierce <pierce@xxxxxxxxxxxx> · Sun, 22 May 2016 23:38:43 -0700



    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