pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rick Gigger <rick@alpinenetworking.com>
To: Keith C. Perry <netadmin@vcsn.com>
Cc: PgSQL General ML <pgsql-general@postgresql.org>
Subject: Re: uploading files
Date: Tue, 18 Nov 2003 12:29:24 -0700
Message-ID: <019f01c3ae0a$46bd1a50$0700a8c0@trogdor> (raw)
References: <1069164075.986.239.camel@bbking.uio.no>
	<20031118142919.GI4953@libertyrms.info>
	<1069180780.2769.91.camel@haggis.homelan>
	<019301c3ae07$d714e220$0700a8c0@trogdor>
	<1069183501.3fba720d48aba@webmail.vcsn.com>

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
>




view thread (10+ messages)  latest in thread

Message-ID: <019f01c3ae0a$46bd1a50$0700a8c0@trogdor>
Permalink:  ../019f01c3ae0a$46bd1a50$0700a8c0@trogdor/
Also on:    postgresql.org/message-id/019f01c3ae0a$46bd1a50$0700a8c0@trogdor

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: rick@alpinenetworking.com, netadmin@vcsn.com, pgsql-general@postgresql.org
  Subject: Re: uploading files
  In-Reply-To: <019f01c3ae0a$46bd1a50$0700a8c0@trogdor>
  References: <1069164075.986.239.camel@bbking.uio.no> <20031118142919.GI4953@libertyrms.info> <1069180780.2769.91.camel@haggis.homelan> <019301c3ae07$d714e220$0700a8c0@trogdor> <1069183501.3fba720d48aba@webmail.vcsn.com> <019f01c3ae0a$46bd1a50$0700a8c0@trogdor>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox