Re: random access - bytea

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: random access - bytea
Дата
Msg-id Pine.LNX.4.44.0310261536010.3817-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: random access - bytea  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
On Sun, 26 Oct 2003, Christopher Kings-Lynne wrote:

> > to find the row and then to perform the substr. An open command can 
> > be optimized a lot more, for example to cache entries that have been 
> > opened so that it's fast to read the next 1kb or whatever you want.
> 
> It's an index scan, so it's pretty fast...

And if you read a lot it will be cached, but it's still a little extra
overhead and the write case it does not solve at all.

-- 
/Dennis



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Call for port reports
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: random access - bytea