Re: random access - bytea - Mailing list pgsql-hackers

From Dennis Bjorklund
Subject Re: random access - bytea
Date
Msg-id Pine.LNX.4.44.0310261536010.3817-100000@zigo.dhs.org
Whole thread Raw
In response to Re: random access - bytea  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Call for port reports
Next
From: Hannu Krosing
Date:
Subject: Re: random access - bytea