From: | Pascal Cohen <pcohen(at)wimba(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: HA and Replication - how to choose among all the available solutions |
Date: | 2007-12-03 19:37:58 |
Message-ID: | 47545B16.7090709@wimba.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andrew Sullivan wrote:
> On Mon, Dec 03, 2007 at 04:16:04PM +0100, Pascal Cohen wrote:
>
>> needs fast connections like fiber channels ? What is the impact on I/O
>> and general DB perfs ? - Sorry if my question is stupid - not an expert
>> on such things.
>> And I suppose it is not very cheap ;)
>>
>
> Well, if you think you're going to get high performance and super
> redundancy on cheap hardware, you need to think again. ECC memory isn't
> cheap either, but if you care about your data, you have to decide whether
> it really needs to be protected.
>
> No, you don't necessarily need fibre. Some people do this over copper-based
> LAN links.
>
>
That is not what I meant.
For example if my DB is 2Gb large, I probably don't need 32Gb RAM.
The same way, if I can get a fast and reliable system with copper based
LAN and not Fiber-Channel, this can save some money that can be used
somewhere else for better use (CPU/RAM for example).
Currently I am not concerned with prices. I am trying to gather as much
information as I can in order to be able to give good "recommendations"
or advices when I could be asked for.
So there are things I can test (mainly softwares) but testing hardware
is less easy.
Thanks
Pascal
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-12-03 19:37:59 | Re: PL/pgSQL and SETOF |
Previous Message | Richard Huxton | 2007-12-03 19:06:29 | Re: stored procedures and dynamic queries |