Re: [PERFORM] reading large BYTEA type is slower than expected

Tom, Actually the 120 records I quoted is a mistake. Since it is a three band image the number of records should be 360 records or 120 records for each band. Mark -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 10:48 AM To: Mark Harris Cc: pgsql

Re: [PERFORM] reading large BYTEA type is slower than expected

I am testing with about 120 records will be fetched from the raster blocks table each time the user pans or zooms. Mark -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 10:48 AM To: Mark Harris Cc: pgsql-performance@postgresql.org Subjec

[PERFORM] reading large BYTEA type is slower than expected

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