| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | "Rick Gigger" <rick(at)alpinenetworking(dot)com> |
| Cc: | "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>, "PgSQL General ML" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: uploading files |
| Date: | 2003-11-18 19:36:24 |
| Message-ID: | 87islhqxjb.fsf@asmodeus.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
"Rick Gigger" <rick(at)alpinenetworking(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2003-11-18 19:50:58 | Re: uploading files |
| Previous Message | Rick Gigger | 2003-11-18 19:29:24 | Re: uploading files |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CoL | 2003-11-18 19:43:18 | Re: indexing with lower(...) -> queries are not optimised very well |
| Previous Message | Rick Gigger | 2003-11-18 19:29:24 | Re: uploading files |