From: David Gagnon <dgagnon@siunik.com>
To: Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Is postgresql ca do the job for software deployed in ASP
Date: Tue, 04 Jul 2006 09:33:20 -0400
Message-ID: <44AA6E20.60205@siunik.com> (raw)
In-Reply-To: <7F10D26ECFA1FB458B89C5B4B0D72C2B4E47DE@sesrv12.wirelesscar.com>
References: <7F10D26ECFA1FB458B89C5B4B0D72C2B4E47DE@sesrv12.wirelesscar.com>
Mikael Carneholm wrote:
>> For my application there is very little info I can share. Maybe less
>>
> than 10 on 100 actually so I not sure it worth it ...
>
> Ok, so 90% of the tables are being written to - this either means that
> your application uses very little constants, or that it has access to
> constans that are stored somewhere else (eg, a JMX Mbean that's
> initialized from property files on application startup). Would it be too
> much work to redesign the DB model to support more than one client?
>
Yes configuration are in property files or somewhere else. I will keep
this solution in mind but for now I really think that would really
complicated for what it will give in return...
>
>> I look into the HP DL385 and DL585 on HP site and they are price
>>
> between
>
>> 3000 and 15000$$ (base price). Thats quite a difference? So is the HP
>>
>
>
>> DL385 with 2 cpus will do the job ?
>>
>
> Yeah, there's quite a difference on the price tags between those two.
> I'd vote for the DL385 since the sockets for the two extra CPU's won't
> give you linear scalability per $ in the end. A single machine may be
> cheaper to administrate, but if administration costs are
> irrelevant/negligible I'd go for several 2-socket machines instead of
> one 4-socket machine.
>
I do need 2 machines since I need an HA solution. So on top of those
question I try to figure out if Slony-I can do the job in my scenario or
do I need the Mammoth solution. I'm searching the list right now and
there is not a lot of info... :-( Any Idea?
So thanks for the info about the DL385 I will look deeply into it !
Best Regards
/David
> /Mikael
>
>
>> -----Original Message-----
>> From: pgsql-performance-owner@postgresql.org
>> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of David
>> Gagnon
>> Sent: den 3 juli 2006 13:42
>> To: pgsql-performance@postgresql.org
>> Subject: [PERFORM] Is postgresql ca do the job for software deployed
>>
> in
>
>> ASP ou SaaS mode?
>>
>> Hi all,
>>
>> I've been working on my personal project for 3.5 years now. I
>> developed an ERP system in web/java. Now the people I will work with
>> suggest to offers it in Saas mode. Which means my customer will
>>
> connect
>
>> to my website and found they ERP software and data there. It's not
>>
> the
>
>> deployment I planned initially so if you can just validate some
>> technicals points to be sure it's not crazy using Postgresl here and
>>
> not
>
>> a big $$$ db to do the job.
>>
>> Typically I will have 1db per client and around 150 tables per db. So
>> since I hope I didn`t work all those year for nothing .. I expect to
>> have bunch of clients witch means the same amount of db since I have 1
>> db/client.
>>
>> Can I hope having several hundred of db on 1 db server? Like 250 dbs
>>
> =
>
>> 250 client = 360 000 tables !!!
>> So is there a limit for the number of db in the db server ?(this spec
>>
> is
>
>> not on the website) What about the performance? Can I expect to have
>>
> the
>
>> same performance?
>>
>> Since I put everything on the web I do needs an High Availability
>> infrastructure. I looked into SlonyI and Mammoth to replicate the db
>> but since SlonyI use triggers can I expect it to do the job? Is
>>
> Mammoth
>
>> is the only available solution?
>>
>> Last question and not the least I'm reading this performance list for
>> several years now and know suggestion about hardware to run postgresl
>>
> is
>
>> discussed. Since I wrote software there severals points about
>>
> hardware
>
>> that I don`t understand. Do you have any suggestion of platform to
>>
> run
>
>> into my Saas configuration? I do need the WISE one! I'm pretty sure
>> that if I was a big company I would be able throw bunch of $$$$ but
>>
> it's
>
>> not my case. I'm pretty sure it exists out there some piece of
>>
> Hardware
>
>> that would do the job perfectly with a fair price.
>>
>> So far I did understand that Postgresql loves Opteron and I have
>>
> looked
>
>> into the dl145 series of HP. I did understand that Dell Hardware it`s
>> not reliable. But it's still not clear what should be my requirement
>> for memory, disk, nb cpu, cpu power, etc.
>>
>> I'm pretty sure it`s better to have more slower CPUs that having the
>> latest Opteron available on the market, or more slower servers that
>> having the fastest one... am I right? But agains what it`s the
>>
> optimal
>
>> choice?
>>
>> Thanks you to share your knowledge on those point. I do consider
>>
> using
>
>> Postgresql is the Smart choice in my project since the beginning but
>> before putting all the money (That I don`t have ..:-)) to buy some
>> hardware I just want to be sure I'm not crazy!
>>
>> Thanks for your help I really appreciate it!!
>>
>> Best Regards
>> /David
>>
>>
>>
>>
>>
>>
>>
>> ---------------------------(end of
>>
> broadcast)---------------------------
>
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dgagnon@siunik.com, Mikael.Carneholm@WirelessCar.com
Subject: Re: Is postgresql ca do the job for software deployed in ASP
In-Reply-To: <44AA6E20.60205@siunik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox