Hi,
I have a table in postgreSQL, ver. 7.4.1, which serves up image
data(JPEG) to users browsers. In various posts I have read there has
been a favour towards storing image data as bytea (byte[]) instead of
storing the filesystem location of the image, or whatever binary data
is, in the database. I have decided to store my images on the database
and wanted to know what *best practice* performance tweaks you suggest
I make to postgreSQL in terms of minimising the time it takes to serve
binary data to users?

many thanks in advance


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match