Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for Copy #25

Open
trailsandtribulations opened this issue Nov 21, 2013 · 1 comment
Open

Support for Copy #25

trailsandtribulations opened this issue Nov 21, 2013 · 1 comment

Comments

@trailsandtribulations
Copy link

in postgresql, the fastest way (by far) to insert rows is through copy.

for larger datasets, this is even faster than prepared statements due to, if nothing else, communication and parsing overhead.

imho this would be right up there with pooling (which you already have) in making pg production ready.

@xxgreg
Copy link
Owner

xxgreg commented Nov 23, 2013

Thanks for opening the issue.

I won't be able to implement this within the next months, for anyone interested in implementing this, the protocol documentation is here:

http://www.postgresql.org/docs/8.1/static/protocol-flow.html#PROTOCOL-COPY

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants