Re: Caching Websites - Mailing list pgsql-general

From Doug McNaught
Subject Re: Caching Websites
Date
Msg-id m3of28i7w8.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Caching Websites  (Adam Kessel <adam@bostoncoop.net>)
Responses Re: Caching Websites  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Adam Kessel <adam@bostoncoop.net> writes:

> Based on the documetation, I don't immediately see any disadvantage to
> using these large objects--does anyone else see why I might not want to
> store archived websites in large objects?

It's going to be (probably) a little slower than the filesystem
solution, and backups are a little more involved (you can't use
pg_dumpall) but everything works--I have been using LOs with success
for a couple years now.

-Doug

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error installing postgresql-7.3.2 (fixed, but Q remains...)
Next
From: Adam Sherman
Date:
Subject: Performance Problem