Re: [GENERAL] File size consideration of file_fdw in PostgreSQL

2013-06-24 Thread Albe Laurenz
Xiaobo Gu wrote: We have very large files in size will be created as external tables in PostgreSQL via file_fdw, we have the following considerations: 1. Can file_fdw handle files with size large than the size of RAM in the server. That shouldn't be a problem. 2. Will file_fdw scan the

[GENERAL] File size consideration of file_fdw in PostgreSQL

2013-06-22 Thread Xiaobo Gu
Hi, We have very large files in size will be created as external tables in PostgreSQL via file_fdw, we have the following considerations: 1. Can file_fdw handle files with size large than the size of RAM in the server. 2. Will file_fdw scan the full file every time when the external table is