Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-07-12 Thread Tom Lane
Etsuro Fujita fujita.ets...@lab.ntt.co.jp writes: Besides the revision, I modified check_selective_binary_conversion() to run heap_close() in the whole-row-reference case. Attached is an updated version of the patch. Applied with minor, mostly-cosmetic revisions. I did fix

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-07-12 Thread Etsuro Fujita
Thanks! Best regards, Etsuro Fujita -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Friday, July 13, 2012 5:30 AM To: Etsuro Fujita Cc: 'Kohei KaiGai'; 'Robert Haas'; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] WIP Patch: Selective binary conversion

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-06-26 Thread Etsuro Fujita
Hi Kaigai-san, -Original Message- From: Kohei KaiGai [mailto:kai...@kaigai.gr.jp] Sent: Monday, June 25, 2012 9:49 PM To: Etsuro Fujita Cc: Robert Haas; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables Fujita

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-06-26 Thread Kohei KaiGai
20, 2012 1:26 AM To: Etsuro Fujita Cc: Robert Haas; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables Hi Fujita-san, Could you rebase this patch towards the latest tree? It was unavailable to apply the patch

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-06-26 Thread Etsuro Fujita
Hi Kaigai-san, -Original Message- From: Kohei KaiGai [mailto:kai...@kaigai.gr.jp] Sent: Tuesday, June 26, 2012 11:05 PM To: Etsuro Fujita Cc: Robert Haas; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables 2012/6

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-06-25 Thread Kohei KaiGai
Etsuro Fujita fujita.ets...@lab.ntt.co.jp: -Original Message- From: Robert Haas [mailto:robertmh...@gmail.com] Sent: Friday, May 11, 2012 1:36 AM To: Etsuro Fujita Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-06-20 Thread Etsuro Fujita
: Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables Hi Fujita-san, Could you rebase this patch towards the latest tree? It was unavailable to apply the patch cleanly. Sorry, I updated the patch. Please find attached an updated version of the patch. I looked

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-06-19 Thread Kohei KaiGai
...@gmail.com] Sent: Friday, May 11, 2012 1:36 AM To: Etsuro Fujita Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables On Tue, May 8, 2012 at 7:26 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: I would like to propose

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-05-10 Thread Robert Haas
On Tue, May 8, 2012 at 7:26 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: I would like to propose to improve parsing efficiency of contrib/file_fdw by selective parsing proposed by Alagiannis et al.[1], which means that for a CSV/TEXT file foreign table, file_fdw performs binary

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-05-10 Thread Etsuro Fujita
-Original Message- From: Robert Haas [mailto:robertmh...@gmail.com] Sent: Friday, May 11, 2012 1:36 AM To: Etsuro Fujita Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables On Tue, May 8, 2012 at 7:26 AM

[HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-05-08 Thread Etsuro Fujita
I would like to propose to improve parsing efficiency of contrib/file_fdw by selective parsing proposed by Alagiannis et al.[1], which means that for a CSV/TEXT file foreign table, file_fdw performs binary conversion only for the columns needed for query processing. Attached is a WIP patch

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-05-08 Thread David Fetter
On Tue, May 08, 2012 at 08:26:02PM +0900, Etsuro Fujita wrote: I would like to propose to improve parsing efficiency of contrib/file_fdw by selective parsing proposed by Alagiannis et al.[1], Is the patch they used against 9.0 published somewhere? Cheers, David. -- David Fetter

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

2012-05-08 Thread Etsuro Fujita
-Original Message- From: David Fetter [mailto:da...@fetter.org] Sent: Wednesday, May 09, 2012 9:25 AM To: Etsuro Fujita Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables On Tue, May 08, 2012 at 08:26:02PM