On fös, 2006-05-19 at 12:21 -0700, Siah wrote:
> Some pointers could help. & any arguments pro/against saving bin data
> in db?
pro: backups can be made with pg_dump only.
if binary data is stored in filesystem, your backup
procedure gets more complicated, specially if your
binary files can get
On Fri, May 19, 2006 at 12:21:28 -0700,
Siah <[EMAIL PROTECTED]> wrote:
> Some pointers could help. & any arguments pro/against saving bin data
> in db?
If you want transactional semantics you want the data in the DB. If not,
then you will probably get better perfomance if it isn't.
---
Some pointers could help. & any arguments pro/against saving bin data
in db?
Thanks,
Sia
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
"Siah" <[EMAIL PROTECTED]> writes:
> Is there any better method of pushing binary data to
> postgres besides parsing it into ascii sql which seems extremely
> inefficient to me.
Yeah, send it as an out-of-line binary parameter. Dunno whether you can
get at that from Python though :-(
