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

2012-07-12 Thread Etsuro Fujita
[HACKERS] WIP Patch: Selective binary conversion of CSV file > foreign tables > > "Etsuro Fujita" 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 >

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

2012-07-12 Thread Tom Lane
"Etsuro Fujita" 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 check_selective_binary_conversion to n

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 fil

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

2012-06-26 Thread Kohei KaiGai
;conflicting or redundant options"))); >> >> Thanks, >> >> 2012/6/20 Etsuro Fujita : >> > Hi KaiGai-san, >> > >> > Thank you for the review. >> > >> >> -Original Message----- >> >> From: pgsql-hackers

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 fil

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

2012-06-25 Thread Kohei KaiGai
on() in the updated version, > and now file_fdw gives up selective binary conversion for the following > cases: > >  a) BINARY format >  b) CSV/TEXT format and whole row reference >  c) CSV/TEXT format and all the user attributes needed > > > Best regards, > Etsuro Fu

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

2012-06-20 Thread Etsuro Fujita
ers@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 cleanly. Sorry, I updated the patch. Please find a

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

2012-06-19 Thread Kohei KaiGai
suro 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 >&

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 > >

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 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 conversion only for > the columns

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

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 http://fette

[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 impleme