Re: Picture with Postgres and Delphi

From: Brian Hirt <bhirt(at)mobygames(dot)com>
To: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
Cc: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>, Edwin Quijada <listas_quijada(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Picture with Postgres and Delphi
Date: 2003-09-10 17:56:52
Message-ID: 28897256-E3B8-11D7-966F-000393D9FD00@mobygames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How do you deal with backing up the images? Right now i can remote
backup my filesystem using rsync to an offsite location many times a
day, only taking a very small amount of I/O, bandwidth and time.
Dealing with the backup scared me away from using postgres in the first
place. The idea of doing a 200gb dump multiple times a day on an
image database scares me. So does doing a vacuum on it. The I/O,
time and bandwidth required to do this is daunting.

Are there any suggestions on how to do incremental backups of the
images and any other suggestions on performance? In the future I'd
like to move some filesystem images to postgres to have a centralized
storage. It would make some things easier, but i'm not sure it's worth
the additional problems. Hopefully i'm imagining the problems.

--brian

On Tuesday, September 9, 2003, at 08:56 PM, Jonathan Bartlett wrote:

>> For the education of me and maybe others too, why was
>> that? i.e. what problems did you run into, that bytea avoids?
>>
>
> Compared to the filesystem, bytea provides data integrity.
>
> Bytea gives you remote access, which you can cache if needed.
>
> Bytea gives you the same permissions as anything else in Postgres, so
> you
> don't have to worry about that separately.
>
> Compared to BLOBs, bytea's are just simpler. You can select them with
> a
> single statement, you don't have to worry about leaving unreferenced
> BLOBs, and, after 4 billion inserts, byteas are still meaningful while
> BLOBs might not be. (due to OID problems).
>
> Jon
>
>
>> __________________________________
>> Do you Yahoo!?
>> Yahoo! SiteBuilder - Free, easy-to-use web site design software
>> http://sitebuilder.yahoo.com
>>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2003-09-10 18:12:51 Re: State of Beta 2
Previous Message Greg Stark 2003-09-10 17:54:31 Re: message type 0x50