Skip site navigation (1) Skip section navigation (2)

Re: Performance and Clustering

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Jaime Rodriguez <jaime(dot)rodriguez(at)liberux(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Performance and Clustering
Date: 2010-04-29 02:43:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On 29/04/2010 10:04 AM, Greg Smith wrote:
> Jaime Rodriguez wrote:
>> My customer requires that DBMS shall support 4000 simultaneous requests
>> Also the system to be deploy maybe a cluster, with 12 microprocessors
> [snip]
> If most connections are read-only, there are a few ways to design a
> cluster of systems to support the sort of design needed to scale up to
> where you're aiming at. Getting more than one node you can write to in a
> cluster is much harder.

If most of the connections are read-only then in addition to using a 
connection pooler and/or read slave cluster, you can look into getting 
the customer to using memcached as a midlayer. They should see a huge 
performance boost if they're prepared to do the work.

Craig Ringer

In response to

pgsql-general by date

Next:From: AndreasDate: 2010-04-29 03:02:58
Subject: Need magic that checks if a collumn contains values that CAN NOT be converted to Latin1
Previous:From: Greg SmithDate: 2010-04-29 02:04:10
Subject: Re: Performance and Clustering

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group