Search Postgresql Archives

Re: Storing images in PostgreSQL databases (again)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Leonel Nunez wrote:
>> I think the arguments for keeping stuff inside the database are
>> (a) far easier to maintain transactional semantics for insert/delete,
>> and (b) easier to serve the data out to clients that aren't on the
>> same machine.  You aren't going to find a performance win though.
>> 
> 
>  (c) easy to replicate

I don't follow that.  Suppose your database minus images is 3 GB, and
your images are another 50 gigabytes.  Which is easier to replicate, 3
or 53?  Put the images on a file server, separate from the DBs - no need
to replicate them.  And if you do want to copy (e.g., your replicated DB
is in a remote location), you can do a simple file system copy to the
corresponding remote file server.

>  (d) easy to  load balancing

If you're load balancing, both databases are in the same location,
right?  In which case you only need one set of images on a central file
server.

-- 
Guy Rouillier



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux