Re: Partitioning / Clustering

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Mohan, Ross" <RMohan(at)arbinet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Partitioning / Clustering
Date: 2005-05-12 18:51:44
Message-ID: 200505121151.45105.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2005-05-12 18:54:48 Re: Sort and index
Previous Message Alex Stapleton 2005-05-12 17:45:32 Re: Partitioning / Clustering