Postgres Pro
Downloads
Home   >   mailing lists

Best Strategy for Large Number of Images - Mailing list pgsql-general

From Estevan Rech
Subject Best Strategy for Large Number of Images
Date
Msg-id CAJZXSXjNC7jf5Z0fdWW09NupOG3KcvX7hDK-abNLcnOj6vwMgQ@mail.gmail.com
Whole thread Raw
Responses Re: Best Strategy for Large Number of Images  (Rob Sargent <robjsargent@gmail.com>)
Re: Best Strategy for Large Number of Images  (Ron <ronljohnsonjr@gmail.com>)
Re: Best Strategy for Large Number of Images  (Bruce Momjian <bruce@momjian.us>)
RE: Best Strategy for Large Number of Images  (Zahir Lalani <ZahirLalani@oliver.agency>)
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Martín Fernández
Date:
Subject: Re: Reindex "locked" standby database
Next
From: Rob Sargent
Date:
Subject: Re: Best Strategy for Large Number of Images