Re: Partitioning / Clustering - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Partitioning / Clustering
Date
Msg-id 200505121151.45105.josh@agliodbs.com
Whole thread Raw
In response to Partitioning / Clustering  (Alex Stapleton <alexs@advfn.com>)
List pgsql-performance
Ross,

> Memcached is a PG memory store, I gather,

Nope.  It's a hyperfast resident-in-memory hash that allows you to stash stuff
like user session information and even materialized query set results.
Thanks to SeanC, we even have a plugin, pgmemcached.

> but...what is squid, lighttpd?
> anything directly PG-related?

No.   These are all related to making the web server do more.   The idea is
NOT to hit the database every time you have to serve up a web page, and
possibly not to hit the web server either.  For example, you can use squid 3
for "reverse" caching in front of your web server, and serve far more page
views than you could with Apache alone.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Alex Stapleton
Date:
Subject: Re: Partitioning / Clustering
Next
From: Manfred Koizar
Date:
Subject: Re: Sort and index