Re: [GENERAL] Image storage questions

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Image storage questions
Date: 2005-05-20 15:39:13
Message-ID: 200505200939.13419.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kelly Burkhart 2005-05-20 15:39:14 Finding IP of front end
Previous Message Bruce Momjian 2005-05-20 15:37:52 Re: numeric precision when raising one numeric to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-05-20 15:51:46 Re: [HACKERS] Inherited constraints and search paths (was Re:
Previous Message Steve Atkins 2005-05-20 15:29:05 Re: Learning curves and such (was Re: pgFoundry)