Delete Account

[Estevan Rech]

Hi,

I want to delete my account (softr...@gmail.com) and all data from
https://www.postgresql.org/

Thanks

Re: Delete Account

[Estevan Rech]

delete account,

Best Strategy for Large Number of Images

[Estevan Rech]

Hi,

I don't currently use PostgreSQL, but I plan to migrate and I have a
question about the best way/strategy for storing images. I have about 2
million images with a growth trend of around 1 million images per year. I
plan to store in bytea format in an isolated table. Is this recommended? Is
there another better way?

Re: Best Strategy for Large Number of Images

[Estevan Rech]

350kb

Em qua., 15 de dez. de 2021 às 14:50, Rob Sargent 
escreveu:

> On 12/15/21 10:45, Estevan Rech wrote:
>
> Hi,
>
> I don't currently use PostgreSQL, but I plan to migrate and I have a
> question about the best way/strategy for storing images. I have about 2
> million images with a growth trend of around 1 million images per year. I
> plan to store in bytea format in an isolated table. Is this recommended? Is
> there another better way?
>
> How big are the images on average?
>

Re: Best Strategy for Large Number of Images

[Estevan Rech]

I think about using it inside the database to facilitate the select and
generation of reports...

>

Re: Best Strategy for Large Number of Images

[Estevan Rech]

But PostgreSQL can handle it? Does it have good search performance? and is
memory usage feasible?

Re: Best Strategy for Large Number of Images

[Estevan Rech]

The possibilities are known, but does anyone have experience with this
scenario?

Re: Best Strategy for Large Number of Images

[Estevan Rech]

Adrian,

I have an application that takes pictures of items and uses them as
evidence in a report.

These images are saved and then used to generate a report.

Each item averages 10 photos and I have about 2 million photos currently,
with an average growth of 1 million photos over the next year.

I think about using it within the database because of the ease of selecting
records with the content of the images (when necessary).

I think my biggest concern is to continue to use this strategy for the next
2 years and encounter a PostgreSQL limitation or some failure and have to
migrate database again or have significant loss of images. And on the
contrary too, if I use it on disk and in 2 years I find some failure or
file limit in the operating system (currently it's windows server 2016)...

Related to this is the backup service that seems to me that in a disaster,
I can restore the database relatively quickly if it's in the database. On
the disk, I believe that the restoration is much slower and I don't think
it's reliable that all the images are copied/restored.

Re: Best Strategy for Large Number of Images

[Estevan Rech]

How is this folder structure like 10,000 folders? and the backup of it, how
long does it take?