Re: using Postgres to store many small files

From: "Bas Scheffers" <bas(at)scheffers(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: hixson(at)poindextrose(dot)org
Subject: Re: using Postgres to store many small files
Date: 2004-03-04 12:12:06
Message-ID: 9981.212.124.229.3.1078402326.squirrel@io.scheffers.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message mbc 2004-03-04 12:35:42 clarification of postgres limitations
Previous Message Gellert, Andre 2004-03-04 12:09:18 Re: Are Postgres 7.4.1 RPMs available for SuSE 9.0 ?