Re: Splitting queries across servers - Mailing list pgsql-general

From Chris
Subject Re: Splitting queries across servers
Date
Msg-id 9a0c82c605012919384723f395@mail.gmail.com
Whole thread Raw
In response to Splitting queries across servers  ("Max" <maxdl@adelphia.net>)
List pgsql-general
On Wed, 26 Jan 2005 08:00:36 -0800, Max <maxdl@adelphia.net> wrote:
> Hello,
>
> Our postgresql database is getting too big to be handled by one server. We
> need the database to be in RAM and cannot afford swapping. At the moment,
> we're using only 3GB or RAM, however our business growth is going to drive
> this number into the double digits zone, maybe triple digits.
>
> What are our options ?
>
Depending on what your queries are like, you might take a look at
memcached (www.danga.com).  It's a distributed memory cache that uses
simple key/value storage, and it's extremely fast and uses very little
cpu.

Chris

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pinning buffers for long times like outer joins might do.
Next
From: "Craig Bryden"
Date:
Subject: PL/pgSQL functions and RETURN NEXT