Re: Using the right tool

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nathan Hopper" <nathanh(at)broszengineering(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using the right tool
Date: 2002-09-09 13:50:45
Message-ID: 10349.1031579445@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Nathan Hopper" <nathanh(at)broszengineering(dot)com> writes:
> But for this task, I've encountered little in the way of stories from users
> who have used Postgres to catalog image data, despite fairly intense
> digging. The thing is, these are not small images by any means. So what
> works well for a few thousand < 250k JPEGS might not work so well for a few
> thousand 25-125 meg TIFFs and SID files.
> Can anyone suggest some references for storage of binary objects of this
> magnitude (100 gig)?

Nathan, I'd suggest talking to the guys at Refractions Inc (Dave Blasby
and Paul Ramsey). I'm pretty sure they have direct experience with
exactly this sort of thing ... but I dunno how closely they follow the
PG mailing lists, so they might not see your request.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Murphy 2002-09-09 14:04:30 Vacuum and indexes problem
Previous Message Tomáš Vondra 2002-09-09 13:43:20 Debugging plpgsql functions