Re: Images storing techniques - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Images storing techniques
Date
Msg-id 8d61f98e-b271-b817-db22-6875442e0def@enterprisedb.com
Whole thread Raw
In response to Images storing techniques  (Riccardo Gobbo <riccardo.gobbo.2@studenti.unipd.it>)
List pgsql-hackers
On 29.03.23 23:29, Riccardo Gobbo wrote:
> Question: for better performance is it better to store images as BYTEA 
> or convert every image in base64 and store the generated string  (so in 
> html it's enough to insert the base64 string in the tag)?
> Converting an image in base64 would use a 30% more memory than storing 
> directly the image's bytes, but I don't know if working with characters 
> rather than bytes could have more prons than cons

Storing as bytea is better.




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: running logical replication as the subscription owner
Next
From: Peter Eisentraut
Date:
Subject: Re: Transparent column encryption