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 7: don't forget to increase your free space map settings
