pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Gregory W Burnham <gburnham@sfu.ca>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Large objects, why not use the filesystem?
Date: Mon, 01 Feb 1999 13:26:09 +0000
Message-ID: <36B5AB71.ACBA1716@alumni.caltech.edu> (raw)
References: <00cc01be4dda$9660fb20$8d0835d1@bconnected.net>

> Ok, I've seen all the xinv* files, I understand that.  But what
> if the benefit of using large objects over files?  If there isn't
> superior performance then why do it?

To provide a consistant access interface in a client-server environment.
Managing one interface is usually easier than managing several (e.g.
postgres, html, ftp, ...) to support a single app. 

I would expect the performance of LOs to be somewhat worse than direct
file system access to the same data, for a variety of reasons. But for
many applications that performance difference is not a critical issue.

                      - Tom



view thread (14+ messages)  latest in thread

Message-ID: <36B5AB71.ACBA1716@alumni.caltech.edu>
Permalink:  ../36B5AB71.ACBA1716@alumni.caltech.edu/
Also on:    postgresql.org/message-id/36B5AB71.ACBA1716@alumni.caltech.edu

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: lockhart@alumni.caltech.edu, gburnham@sfu.ca
  Subject: Re: [INTERFACES] Large objects, why not use the filesystem?
  In-Reply-To: <36B5AB71.ACBA1716@alumni.caltech.edu>

* 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