On Mon, Aug 17, 2015 at 3:14 PM, Bear Giles <bgi...@coyotesong.com> wrote: > I'm starting to work on a tar FDW as a proxy for a much more specific FDW. > (It's the 'faster to build two and toss the first away' approach - tar lets > me get the FDW stuff nailed down before attacking the more complex > container.) It could also be useful in its own right, or as the basis for a > zip file FDW.
Hm. tar may be a bad fit where zip may be much easier. Tar has no index or table of contents. You have to scan the entire file to find all the members. IIRC Zip does have a table of contents at the end of the file. The most efficient way to process a tar file is to describe exactly what you want to happen with each member and then process it linearly from start to end (or until you've found the members you're looking for). Trying to return meta info and then go looking for individual members will be quite slow and have a large startup cost. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers