Re: random access - bytea

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Joe Conway <mail(at)joeconway(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: random access - bytea
Date: 2003-10-26 14:38:35
Message-ID: Pine.LNX.4.44.0310261536010.3817-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2003-10-26 14:56:12 Re: random access - bytea
Previous Message Bruce Momjian 2003-10-26 14:31:19 Re: Call for port reports