This is a discussion on Re: COPY FROM performance improvements within the Pgsql Patches forums, part of the PostgreSQL category; --> Alon Goldshuv wrote: >I revisited my patch and removed the code duplications that were there, and >added support for ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Alon Goldshuv 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. > >Patch attached. > > > I do not have time to review this 2900 line patch analytically, nor to benchmark it. I have done some functional testing of it on Windows, and tried to break it in text and CSV modes, and with both Unix and Windows type line endings - I have not observed any breakage. This does need lots of eyeballs, though. cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |