Postgres Pro
Downloads
Home   >   mailing lists

Blob data type and it's efficiency on PostgreSQL - Mailing list pgsql-general

From Stas Oskin
Subject Blob data type and it's efficiency on PostgreSQL
Date
Msg-id 200509191533.BLP07496@nitzan.inter.net.il
Whole thread Raw
Responses Re: Blob data type and it's efficiency on PostgreSQL
List pgsql-general
Tree view

Hi.

 

We are using PostgreSQL as the RDBMS for our product, and are very happy with it. Recently, we have encountered a need to store a lot of binary files, mainly images (up to ~100,000 files, with sizes varying from 300K-2MB).

 

The question is, how well PostgreSQL performs with the blob data type, and is it practical to store these files as blobs?

 

Thanks in advance,

Stas Oskin.

pgsql-general by date:

Previous
From: Oleg
Date:
Subject: problem with updateable view and constraint
Next
From: "Reid Thompson"
Date:
Subject: Re: Arrrr... date formatting.