Re: Architectural question

From: Moreno Andreo
Subject: Re: Architectural question
Date: ,
Msg-id: 56F2739E.7040803@evolu-s.it
(view: Whole thread, Raw)
In response to: Re: Architectural question  (Thomas Kellerer)
List: pgsql-performance

Tree view

Architectural question  (Moreno Andreo, )
 Re: Architectural question  (Jim Nasby, )
  Re: [SPAM] Re: Architectural question  (Moreno Andreo, )
   Re: [SPAM] Re: Architectural question  (Jim Nasby, )
    Re: [SPAM] Re: Architectural question  (Moreno Andreo, )
     Re: [SPAM] Re: Architectural question  (Jim Nasby, )
      Re: [SPAM] Re: Architectural question  (Moreno Andreo, )
    Re: Architectural question  (Thomas Kellerer, )
     Re: Architectural question  (Moreno Andreo, )
     Re: Architectural question  ("Mike Sofen", )
      Re: Architectural question  (Rick Otten, )
      Re: Architectural question  (Moreno Andreo, )

Il 23/03/2016 10:50, Thomas Kellerer ha scritto:
> Jim Nasby schrieb am 11.03.2016 um 17:37:
>> If the blob is in the database then you have nothing extra to do. It's handled just like all your other data.
>>
>> If it's a file in a file system then you need to:
>>
>> - Have application code that knows how and where to get at the file
>> - Have a way to make those files available on all your webservers
>> - Have completely separate backup and recovery plans for those files
>>
>> That's a lot of extra work. Sometimes it's necessary, but many times it's not.
> Don't forget the code you need to write to properly handle transactional access (writing, deleting) to the files
>
> You usually also need to distribute the files over many directories.
> Having millions of files in a single directory is usually not such a good idea.
>
> In my experience you also need some cleanup job that removes orphaned files from the file system.
> Because no matter how hard you try, to get updates/writes to the file system right, at some point this fails.
>
> Also from a security point of view having this in the database is more robust then in the file system.
>
> The downside of bytea is that you can't stream them to the client. The application always needs to read the whole
blobinto memory before it can be used. This might put some memory pressure on the application server. 
>
> Thomas
>
>
>
>
I just wrote about it in my last message that I sent a few minutes ago
We have blobs in a reserved table in each customer database, so we can
keep up with privacy, since every blob is encrypted... so no extra work :-)

Thanks
Moreno.-





pgsql-performance by date:

From: Rick Otten
Date:
Subject: Re: Architectural question
From: Moreno Andreo
Date:
Subject: Re: Architectural question