Re: Caching Websites

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Ericson Smith <eric(at)did-it(dot)com>
Cc: Doug McNaught <doug(at)mcnaught(dot)org>, Adam Kessel <adam(at)bostoncoop(dot)net>, Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Caching Websites
Date: 2003-05-12 17:27:57
Message-ID: Pine.LNX.4.33.0305121127010.27096-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

And if you're looking at performance caching, try SQUID. It's complex to
setup for most stuff, but as a simple single site http accelerator, it's
pretty fast, and not nearly as hard to setup as when it is using a
redirector (i.e. multi-backend / multi-frontend setup).

On 12 May 2003, Ericson Smith wrote:

> Maybe a little out of the loop... but if you're caching website stuff
> (html?, xml?), then it might be best not to use the Database. If your DB
> goes down... your content site goes down too.
>
> I remember a project a little while back where we actually used plain
> ol, DBM files to cache the content. It was tens of times faster than the
> database, and would stay up no matter what.
>
> I see what your're saying about the LO's but IMHO, the DB is not the
> best place for cached content.
>
> - Ericson Smith
> eric(at)did-it(dot)com
>
> On Mon, 2003-05-12 at 12:04, scott.marlowe wrote:
> > On 12 May 2003, Doug McNaught wrote:
> >
> > > "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> > >
> > > > The advantage to storing them in bytea or text with base64 is that
> > > > pg_dump backs up your whole database.
> > >
> > > It does with LOs too; you just have to use the -o option and either
> > > the 'custom' or 'tar' format rather than straight SQL.
> >
> > Cool. I could of sworn that you had to back them up seperately. Was that
> > the case at one time?
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tilo Schwarz 2003-05-12 18:18:12 ERROR: Memory exhausted in AllocSetAlloc(188)
Previous Message Ericson Smith 2003-05-12 17:27:42 Re: Caching Websites