Re: uploading files
От | Rick Gigger |
---|---|
Тема | Re: uploading files |
Дата | |
Msg-id | 019f01c3ae0a$46bd1a50$0700a8c0@trogdor обсуждение исходный текст |
Ответ на | Point-in-time data recovery - v.7.4 (Rafael Martinez Guerrero <r.m.guerrero@usit.uio.no>) |
Ответы |
Re: uploading files
|
Список | pgsql-general |
I will search the archives but does anyone know off the top of their head which performs better? ----- Original Message ----- From: "Keith C. Perry" <netadmin@vcsn.com> To: "Rick Gigger" <rick@alpinenetworking.com> Cc: "PgSQL General ML" <pgsql-general@postgresql.org> Sent: Tuesday, November 18, 2003 12:25 PM Subject: Re: [GENERAL] uploading files > Quoting Rick Gigger <rick@alpinenetworking.com>: > > > What is the best method for storing files in postgres? Is it better to use > > the large object functions or to just encode the data and store it in a > > regular text or data field? > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > Rick, > > This has been discussed recently so you might want to dig through the archives > but one thing to be aware of is that with large objects, you have have to dump > your database in a different format- a non-text format. This is less portable > than storing files as bytea's which can be dumped in the text and non-text > formats. Argueably is all you use is PosgreSQL then this might not be a big deal. > > Performance-wise I'm not qualified to speak to which is "better". As always, it > is going to depend on your specific application and environment. > > -- > Keith C. Perry, MS E.E. > Director of Networks & Applications > VCSN, Inc. > http://vcsn.com > > ____________________________________ > This email account is being host by: > VCSN, Inc : http://vcsn.com >
В списке pgsql-general по дате отправления: