X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 509EB9FB1D4 for ; Tue, 11 Jul 2006 23:46:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 18506-09 for ; Tue, 11 Jul 2006 23:45:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by postgresql.org (Postfix) with ESMTP id 5CA929FB1D3 for ; Tue, 11 Jul 2006 23:45:59 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id s49so31134pyc for ; Tue, 11 Jul 2006 19:45:57 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=BCOItqmT1jfc490b7VdyPdiQ3Vefyz96+CCFyXQYknOsk4f1Rwm1SVI5ASMcTK1qJxUToT7I1XrKZxSm5Ti8HZxXjuz3KZ4tzze13OrlfeQhv4upnZp2UHu4h7o+9BBNI6FC+hKiXy2m4DjYVr164vrW1R3RXZ32AIXs4kIhnGI= Received: by 10.35.101.9 with SMTP id d9mr325464pym; Tue, 11 Jul 2006 19:45:57 -0700 (PDT) Received: by 10.35.62.5 with HTTP; Tue, 11 Jul 2006 19:45:57 -0700 (PDT) Message-ID: <866624ef0607111945u16897b04t276177b2d2e0c910@mail.gmail.com> Date: Tue, 11 Jul 2006 22:45:57 -0400 From: "Paul S" To: pgsql-admin@postgresql.org Subject: Re: Using PostgreSQL and MIcrosoft SQLServer on the same server In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3375_25753582.1152672357610" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/74 X-Sequence-Number: 22320 ------=_Part_3375_25753582.1152672357610 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I would have to agree with Benjamin here. With the money you save by running Postgres, you can buy another server. :) Regards, Paul On 6/26/06, Benjamin Krajmalnik wrote: > > In addition to what Rodrigo said so eloquently in Portuguese (no fallu > prtugues! ), the only issue you will experience is a performance hit= . > > It is not a good idea to have 2 separate database servers running on the > same set of drive spindles. I usually deploy them in different servers. > That way, the MS SQL Servr has priority access to the resources on the SQ= L > Server box,, and the PostgreSQL on the PostgreSQL box. The other thing t= o > take into account is that SQL Server needs lots of memory to operate, > whereas from my experience PostgreSQL is a lot better with resources. > Depending on the amount of memory on the box, PostgreSQl may not have eno= ugh > left for it by SQL Server to run effectively. > > > > > ------------------------------ > > *From:* pgsql-admin-owner@postgresql.org [mailto: > pgsql-admin-owner@postgresql.org] *On Behalf Of *Rodrigo Sakai > *Sent:* Monday, June 26, 2006 2:25 PM > *To:* '=C9rica J. B. Viana Cruz'; pgsql-admin@postgresql.org > *Subject:* RES: [ADMIN] Using PostgreSQL and MIcrosoft SQLServer on the > same server > > > > Cara amiga brasileira! Como j=E1 respondido pelo Magnus, n=E3o tem > absolutamente nenhum problema! Mas veja que se for um ambiente em produ= =E7=E3o > isso pode gerar problemas futuros em rela=E7=E3o ao desempenho! > > Abra=E7os! > > > > > ------------------------------ > > *De:* pgsql-admin-owner@postgresql.org [mailto: > pgsql-admin-owner@postgresql.org] *Em nome de *=C9rica J. B. Viana Cruz > *Enviada em:* segunda-feira, 26 de junho de 2006 10:19 > *Para:* pgsql-admin@postgresql.org > *Assunto:* [ADMIN] Using PostgreSQL and MIcrosoft SQLServer on the same > server > > > > Dear colleagues, > > > > Good morning and greetings from Brazil!! > > May anyone help me with a question... > > > > I'm working on a project and we are supposed to use Microsoft > SQLServer and PostgreSQL on the same server. There was any problem or ris= k > on this? Anyone has worked on the same situation? > > > > I searched on the web and on documentation and I could not find out > comments about it. > > > > Any help will be appreciated :) > > > > Thanks in advance, > -- > =C9rica J. B. Viana Cruz > ericaviana@gmail.com > ------=_Part_3375_25753582.1152672357610 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
I would have to agree with Benjamin here.  With the money you sav= e by running Postgres, you can buy another server.   :)
 
Regards,
 
Paul
 


 
On 6/26/06, = Benjamin Krajmalnik <kraj@illume= n.com> wrote:

In addition to what Rodrigo said so= eloquently in Portuguese (no fallu prtugues! <vbg>), the only issue = you will experience is a performance hit.

It is not a good idea to have 2 sep= arate database servers running on the same set of drive spindles.  I u= sually deploy them in different servers.  That way, the MS SQL Servr h= as priority access to the resources on the SQL Server box,, and the Postgre= SQL on the PostgreSQL box.  The other thing to take into account is th= at SQL Server needs lots of memory to operate, whereas from my experience P= ostgreSQL is a lot better with resources.  Depending on the amount of = memory on the box, PostgreSQl may not have enough left for it by SQL Server= to run effectively.

 

 


From: pgsql-admin-owner@postgresql.org [mailto:pgs= ql-admin-owner@postgresql.org ] On Behalf Of Rodrigo = Sakai
Sent: Monday, June= 26, 2006 2:25 PM
To: '= =C9rica J. B. Viana Cruz';=20 pgsql-admin@postgresql.org
Subject: RES: [ADMIN] Using PostgreSQL and MIcrosoft SQLServer o= n the same server

  Cara ami= ga brasileira! Como j=E1 respondido pelo Magnus, n=E3o tem absolutamente ne= nhum problema! Mas veja que se for um ambiente em produ=E7=E3o isso pode ge= rar problemas futuros em rela=E7=E3o ao desempenho!

  Abra=E7os!

 =

 


De: pgsql-admin-owner@postgresql.org [mailto: pgsql-admin-owner@postgresql.org] = Em nome de =C9rica J. B. Viana Cruz
Enviada em: segunda-feira, 26 de junho de 2006 10:19=
Para: pgsql-= admin@postgresql.org
Assunto: [ADMIN] Us= ing PostgreSQL and MIcrosoft SQLServer on the same server

 

Dear colleagues,

 

     Good morning and greetings from B= razil!!

     May anyone help me with a qu= estion...

 

     I'm working on a project&nbs= p;and we are supposed to use Microsoft SQLServer and PostgreSQL on the same= server. There was any problem or risk on this? Anyone has worked on the sa= me situation?

 

    I searched on the web and on documentat= ion and I could not find out comments about it.

 

    Any help will be appreciated :)<= /font>

 

Thanks in advance,   
-- =
=C9rica J. B. Viana Cruz
ericaviana@gmail.com


------=_Part_3375_25753582.1152672357610--