Hosting Provided By

Re: [JDBC] JDBC causing the connection to close after executing a COPY command

From: Altaf Malik <mmalik_altaf(at)yahoo.com>
Date: Fri Dec 14 2007 - 16:50:52 EST

I am attaching the new patch.

For CopyInResponse, client will send a CopyFail message and server won't wait for the client input. For CopyOutResponse, exception is generated for only CopyOutResponse and not for every CopyData message. Also slightly changed the 'ignoring' mechanism from reading the message to ignore it to skipping the message. I hope this will also improve the performance.

Altaf Malik
EnterpriseDB
http://www.enterprisedb.com/

Kris Jurka <books@ejurka.com> wrote:

In the case of copying data from the server, if you do have a large table, you'll generate a SQLException for every row of the copy result which isn't great, but I guess it's better than failing completely.

Trying to copy out a single column table of 100k integers took about seven minutes and 150 MB of memory here.

Also, it doesn't work for copying data to the server. In that case the server is sitting waiting for data and the driver is waiting for the server and nothing happens. That was the case before, so this is no worse.

Do you have plans to work on this further or shall I apply just this minor improvement?

Do you need help?

Kris Jurka

          Best Regards
  Muhammad Altaf Malik
Sr. Software Engineer,
EnterpriseDB (SMC) (pvt) Ltd.
  3rd floor, Software Technology Park,
Islamabad. Ph: +92 (051) 2873815
  Cell: 0321-5177961

Never miss a thing. Make Yahoo your homepage.

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

text/x-patch attachment: 2290331491-pg_copy.diff

Received on Fri Dec 14 16:52:05 2007

This message: [ Message body ]
Next message: Kris Jurka: "Re: [JDBC] how to set a PreparedStatement column of XML type in 8.3?"
Previous message: Kris Jurka: "Re: [JDBC] how to set a PreparedStatement column of XML type in 8.3?"
In reply to: Kris Jurka: "Re: [JDBC] JDBC causing the connection to close after executing a COPY command"
Next in thread: Kris Jurka: "Re: [JDBC] JDBC causing the connection to close after executing a COPY command"
Reply: Kris Jurka: "Re: [JDBC] JDBC causing the connection to close after executing a COPY command"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:41:32 EDT