Re: Splitting queries across servers

From: Chris <pglist(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Splitting queries across servers
Date: 2005-01-30 03:38:18
Message-ID: 9a0c82c605012919384723f395@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 26 Jan 2005 08:00:36 -0800, Max <maxdl(at)adelphia(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Bryden 2005-01-30 08:54:21 PL/pgSQL functions and RETURN NEXT
Previous Message Tom Lane 2005-01-30 02:58:52 Re: Pinning buffers for long times like outer joins might do.