Re: Data type for storing images?

<drevil@sidereal.kz> writes:
> I would like to store some images in my Postgres database.  These will
> all be thumbnails, limited to 4k or 5k.  I know that PG has an 8k row
> limit, but this should be fine, because there's not much else in the
> row.  Which data type could I use to store them, and is there a
> performance cost for having rows that are this big?  The system will
> be using PG7.1, btw.

bytea is probably your best bet.  The 8k limit is toast in 7.1, btw.

            regards, tom lane