Skip site navigation (1) Skip section navigation (2)

Re: BLOBs and a virtual file system

From: Peter Martini <peterm(at)processflo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: BLOBs and a virtual file system
Date: 2004-06-23 19:07:42
Message-ID: 1088017662.2323.13.camel@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
I'm not sure what you mean by breaking blobs transactional integrity. 
Do you mean by allowing filesystem type access, the blobs won't be
properly locked and updated during a transaction?  If so, that's exactly
what I'm trying to achieve - a compromise between forcing the files to
be stored solely in the database (maintaining integrity but sacrificing
functionality) or referencing their names to gain functionality, but at
a greater cost.
More to the point, wouldn't file locking mechanisms, and the possibility
of limiting file visibility through the virtual filesystem, allow
transactional integrity to be maintained?  If not, could you explain
where the problem is so I can look further into it?


On Wed, 2004-06-23 at 11:48, Tom Lane wrote:
> Peter Martini <PeterM(at)processflo(dot)com> writes:
> > Lately I've been planning work on a patch to postgres and linux on my
> > system to allow access to BLOBs as a virtual filesystem, so I can see
> > any file I put in there even through network shares while avoiding
> > duplication / broken link issues.  Does this sound like something worth
> > doing / is there a better way to safely reference files from both inside
> > and outside postgres?
> How would you do that without breaking transactional integrity for
> blobs?  There'd be no way to deal with multiple row versions in such
> a representation.
> 			regards, tom lane

In response to


pgsql-hackers by date

Next:From: Frank WilesDate: 2004-06-23 19:16:51
Subject: Re: BLOBs and a virtual file system
Previous:From: Gaetano MendolaDate: 2004-06-23 18:55:59
Subject: Re: warning missing

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group