Re: Question about load balance

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about load balance
Date: 2012-06-11 21:56:42
Message-ID: CAPTjJmq+4F7GsJUfF=ZGhgagUUoJUr-OFH-jtyr_A7gFY3XHXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 12, 2012 at 5:17 AM, Condor <condor(at)stz-bg(dot)com> wrote:
> On 2012-06-11 21:03, John R Pierce wrote:
>>
>> On 06/11/12 2:11 AM, Condor wrote:
>>>
>>> Yes, I now but these parameters can't be increase forever. It's can but
>>> isn't cheep.
>>> For that reason I looking some other ways.
>>
>> why don't you worry about that when you get there, rather than before
>> you even start?
>
> May be because some times when some one start a new business does not have
> 20k $ for
> a new server and resource of the server is enough for the moment and as I
> planed

Postgres performance is pretty awesome even on a cheap laptop. I've
done thrash testing on a basic unit that forms the backbone of our
dev/test system, and also on a similar laptop that has a couple
hundred dollars of SSD replacing its standard hard drive, and both of
them can handle more TPS than you would think to look at them. (I
don't actually have database-level TPS ratings for them, but they
managed 5-10K items per second of conceptual throughput - each "item"
involving quite a bit of processing.) Put it onto some real server
hardware, even just $1K or so, and you'll have something that you can
upgrade for as long as you need to.

ChrisA

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ken Tanzer 2012-06-12 00:17:21 Re: Counting # of consecutive rows with specified value(s)?
Previous Message John R Pierce 2012-06-11 19:47:36 Re: Question about load balance