Re: uploading files - Mailing list pgsql-general

From Doug McNaught
Subject Re: uploading files
Date
Msg-id 87islhqxjb.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Point-in-time data recovery - v.7.4  (Rafael Martinez Guerrero <r.m.guerrero@usit.uio.no>)
List pgsql-general
"Rick Gigger" <rick@alpinenetworking.com> writes:

> I will search the archives but does anyone know off the top of their head
> which performs better?

It really depends on what you are trying to do.  If you are always
fetching the entire file from the database, 'bytea' *might* have a
little less overhead, but it's not clearcut.

Both of them will be ultimately limited by how fast you can get data
off the disk and and pump it through your client connection.

-Doug

pgsql-general by date:

Previous
From: "Rick Gigger"
Date:
Subject: Re: uploading files
Next
From: Karsten Hilbert
Date:
Subject: Re: uploading files