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

From Christopher Kings-Lynne
Subject Re: random access - bytea
Date
Msg-id 3F9B86B1.10306@familyhealth.com.au
Whole thread Raw
In response to Re: random access - bytea  (Dennis Bjorklund <db@zigo.dhs.org>)
Responses Re: random access - bytea  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-hackers
> This would imply that every little read would have to do a scan on a table 
> 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...

Chris




pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Timestamp docs weirdness
Next
From: Christopher Kings-Lynne
Date:
Subject: Coding help