Re: Storing images in PostgreSQL databases (again) - Mailing list pgsql-general

From Leonel Nunez
Subject Re: Storing images in PostgreSQL databases (again)
Date
Msg-id 37888.201.155.188.137.1160062963.squirrel@enelserver.com
Whole thread Raw
In response to Re: Storing images in PostgreSQL databases (again)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Storing images in PostgreSQL databases (again)
List pgsql-general
> "Merlin Moncure" <mmoncure@gmail.com> writes:
>> ... postgresql will toast all images over a cerain size which
>> is actually pretty efficient although can be a problem if your images
>> are really big.
>
> But any reasonable image format is compressed already (or at least, if
> you are using an uncompressed format while worried about disk space then
> you need some time at image processing boot camp).  TOAST isn't going to
> accomplish anything.
>
> 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
 (d) easy to  load balancing


leonel



pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Generating synthetic keys on copy
Next
From: "Brian J. Erickson"
Date:
Subject: PostgreSQL Database Transfer between machines(again)