"Mark Harris" <[EMAIL PROTECTED]> writes: > We have recently ported our application to the postgres database. For > the most part performance has not been an issue; however there is one > situation that is a problem and that is the initial read of rows > containing BYTEA values that have an average size of 2 kilobytes or > greater. For BYTEA values postgres requires as much 3 seconds to read > the values from disk into its buffer cache.
How large is "large"? (No, I don't believe it takes 3 sec to fetch a single 2Kb value.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend