| From: | Mark Wong <markw(at)osdl(dot)org> |
|---|---|
| To: | "Alon Goldshuv" <agoldshuv(at)greenplum(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: COPY FROM performance improvements |
| Date: | 2005-07-19 19:54:53 |
| Message-ID: | 200507191954.j6JJsVjA003280@smtp.osdl.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches pgsql-performance |
On Thu, 14 Jul 2005 17:22:18 -0700
"Alon Goldshuv" <agoldshuv(at)greenplum(dot)com> wrote:
> I revisited my patch and removed the code duplications that were there, and
> added support for CSV with buffered input, so CSV now runs faster too
> (although it is not as optimized as the TEXT format parsing). So now
> TEXT,CSV and BINARY are all parsed in CopyFrom(), like in the original file.
Hi Alon,
I'm curious, what kind of system are you testing this on? I'm trying to
load 100GB of data in our dbt3 workload on a 4-way itanium2. I'm
interested in the results you would expect.
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-07-19 20:11:35 | Re: [HACKERS] Patch to fix plpython on OS X |
| Previous Message | Michael Fuhr | 2005-07-19 19:54:00 | Re: Patch to fix plpython on OS X |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Crosby | 2005-07-19 20:08:11 | Re: Looking for tips |
| Previous Message | Jeff Trout | 2005-07-19 19:53:04 | Re: Looking for tips |