Re: [GENERAL] Image storage questions - Mailing list pgsql-hackers

From Ed L.
Subject Re: [GENERAL] Image storage questions
Date
Msg-id 200505200939.13419.pgsql@bluepolka.net
Whole thread Raw
Responses Re: [GENERAL] Image storage questions
List pgsql-hackers
I asked this on general, but got no answer on this particular 
point, maybe someone here knows.  Are blobs are stored in the 
shared memory cache upon retrieval?  

I ask because we're trying to decide whether to store an enormous 
number of images in PostgreSQL, and I'd be concerned that 
frequent retrieval of those images would effectively empty the 
cache of the rest of the non-image data.

I watched the pg_statio* numbers during some test retrievals, and 
it appears the reads and cache hits on the binary image data are 
not being counted.  I'm wondering if that is the truth of what's 
going on, or just an accounting oversight.

Thanks.



pgsql-hackers by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Learning curves and such (was Re: pgFoundry)
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Inherited constraints and search paths (was Re: