Re: [INTERFACES] Large objects, why not use the filesystem? - Mailing list pgsql-interfaces

From Gene Selkov Jr.
Subject Re: [INTERFACES] Large objects, why not use the filesystem?
Date
Msg-id 199902010723.BAA13407@mail.xnet.com
Whole thread Raw
In response to Re: [INTERFACES] Large objects, why not use the filesystem?  ("Gregory W Burnham" <gburnham@sfu.ca>)
List pgsql-interfaces
> Right.  That would be a place where you couldn't use Matthew's
> suggestion.  But in my case my 'client' is, ultimately, a cgi.
> And now I'm wondering, why am I not using files?  I would hope
> that postgres would be providing me with some kind of superior
> performance than the file system.  Infact, I've always assumed
> it.  But was I right to assume that?  Are there benchmarks out
> there?

No benchmarks are needed. Large objects are stored one per file,
therefore you will see the same preformance.

--Gene

pgsql-interfaces by date:

Previous
From: "Gene Selkov Jr."
Date:
Subject: Re: [INTERFACES] Large objects, why not use the filesystem?
Next
From: Urban Widmark
Date:
Subject: Re: [INTERFACES] ResultSet.getDate