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
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 |