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.
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 |
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) |