Re: [GENERAL] Image File System Question

2005-11-04 Thread Jan Peterson
We have a similar functional requirement to Vishal's, but with an added twist. Currently, we are utilizing the pg_largeobject table to store context data delivered through our java application. We are finding, however, that very large pg_largeobject tables degrade our performance in other areas (

Re: [GENERAL] Image File System Question

2005-11-04 Thread vishal saberwal
thanks for all your prompt reponses but i am still not clear with the way to solve the problem.I am sorry if i wasn't clear with my problem the first time. My problem isn't file system and the way i lay it out. What i need to know is a way to stream out external resource files via  stored procedu

Re: [GENERAL] Image File System Question

2005-11-04 Thread Csaba Nagy
See my comments below. On Fri, 2005-11-04 at 15:24, vishal saberwal wrote: > thanks for your response, > > We are kind of jailing (may be hiding would be a better term) > resources behind the database/Stored procedures and GUI needs to have > a feel as if the data is comming from database. > Its

Re: [GENERAL] Image File System Question

2005-11-04 Thread Douglas McNaught
vishal saberwal <[EMAIL PROTECTED]> writes: > HFS is the filesystem richard was tlking about. I am not familiar with > this file system but i guessed it was HFS+ that he was talking about. > yes, i understand all modern filesystems are Hirearchical file systems. Oh, OK--reading your original mess

Re: [GENERAL] Image File System Question

2005-11-04 Thread Richard Huxton
vishal saberwal wrote: HFS is the filesystem richard was tlking about. I am not familiar with this file system but i guessed it was HFS+ that he was talking about. yes, i understand all modern filesystems are Hirearchical file systems. Ah, you said (H)ierarchical (F)ile (S)ystem in the origina

Re: [GENERAL] Image File System Question

2005-11-04 Thread vishal saberwal
HFS is the filesystem richard was tlking about. I am not familiar with this file system but i guessed it was HFS+ that he was talking about. yes, i understand all modern filesystems are Hirearchical file systems. thanks, vishOn 11/4/05, Douglas McNaught <[EMAIL PROTECTED]> wrote: vishal saberwal <

Re: [GENERAL] Image File System Question

2005-11-04 Thread Douglas McNaught
vishal saberwal <[EMAIL PROTECTED]> writes: > Did try finding something about HFS for ext3/xfs but in vain. The > information i found was the conversion between these file systems. What exactly do you mean by HFS? All modern filesystems are hierarchical. -Doug ---(end o

Re: [GENERAL] Image File System Question

2005-11-04 Thread vishal saberwal
thanks for your response, We are kind of jailing (may be hiding would be a better term) resources behind the database/Stored procedures and GUI needs to have a feel as if the data is comming from database. Its a requirement for the project that any communication of resources and data be done throu

Re: [GENERAL] Image File System Question

2005-11-04 Thread Richard Huxton
vishal saberwal wrote: hi, My server is Postgres 8.0.1 on fedora core2. My clients are remote and interface with my server using .NET GUI. We are trying to store many images/icons/audio/video clips in our system. We expect many of these. The way we are doing it is using Hierarchical File Syste