Re: reading large BYTEA type is slower than expected

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: reading large BYTEA type is slower than expected
Дата
Msg-id 259.1179510482@sss.pgh.pa.us
обсуждение исходный текст
Ответ на reading large BYTEA type is slower than expected  ("Mark Harris" <mharris@esri.com>)
Ответы Re: reading large BYTEA type is slower than expected  ("Mark Harris" <mharris@esri.com>)
Re: reading large BYTEA type is slower than expected  ("Mark Harris" <mharris@esri.com>)
Список pgsql-performance
"Mark Harris" <mharris@esri.com> 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Mark Harris"
Дата:
Сообщение: reading large BYTEA type is slower than expected
Следующее
От: "Y Sidhu"
Дата:
Сообщение: Re: reading large BYTEA type is slower than expected