Re: using Postgres to store many small files - Mailing list pgsql-general

From Bas Scheffers
Subject Re: using Postgres to store many small files
Date
Msg-id 9981.212.124.229.3.1078402326.squirrel@io.scheffers.net
Whole thread Raw
In response to using Postgres to store many small files  (Matthew Hixson <hixson@poindextrose.org>)
List pgsql-general
I am assuming these are mugshots displayed on web pages? Put them in
Postgres by all means, I would, but push them out to the file system as
well so the webserver can return them directly, saving database access CPU
cycles. Intercept 404s with a jsp that checks if it was an image being
asked for. If it was and it can find it in the DB, push it out to the
client and write it to disk for the next time. Or run a nightly script
that checks for missing files.

Bas.

pgsql-general by date:

Previous
From: "Gellert, Andre"
Date:
Subject: Re: Are Postgres 7.4.1 RPMs available for SuSE 9.0 ?
Next
From: mbc@soliton.com
Date:
Subject: clarification of postgres limitations