| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Large objects [BLOB] again - general howto |
| Date: | 2003-11-29 10:10:52 |
| Message-ID: | 20031129101052.C9760@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 25/11/2003 21:55 Jeremiah Jahn wrote:
> [snip]
> I have found that it is best to have a separate connection for BLOB's
> and one for everything else. Mind you, this is with Java, but the
> autocommit settings on the connection don't appear to be thread safe, so
> in high traffic you can accidentally cut off a transfer, or stop one
> before it ever starts.
How could a connection ever have the kind of "thread-safe" behavior you
seem to believe it should have?
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Unihost Web Hosting | 2003-11-29 11:41:31 | Re: PostgreSQL Advocacy, Thoughts and Comments |
| Previous Message | Unihost Web Hosting | 2003-11-29 10:07:17 | Re: Postgresql on file system EXT2 or EXT3 |