Using threads in FDW for read-ahead
Noah Watkins <[email protected]> Tue, 10 Jun 2014 12:10:22 -0700
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <CAB2gnbUqOGZi4u8ohKGqFdvtqEz4F6LE5kedHRKJBHO7z3YdcA@mail.gmail.com> |
I have created a FDW for a storage backend and it is working well, and now I would like to overlap processing with I/O by performing read-ahead. I started by using a thread to do background I/O and this worked, but problems started to arise when I tried to do predicate filtering in the thread. In particular, it seems as though `check_stack_depth` is built to assume a single threaded environment (`stack_base_ptr` is global). I'm wondering if there is a solution to this problem, or if there are examples of overlapping tuple I/O and predicate filtering using non-multithreading techniques? Thanks, Noah