From troygeekdatabase@gmail.com Thu Jan 20 05:03:49 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AC9A73A467E for ; Thu, 20 Jan 2005 05:03:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16528-10 for ; Thu, 20 Jan 2005 05:03:40 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id 3C7F03A18CF for ; Thu, 20 Jan 2005 05:03:37 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id r35so52833rna for ; Wed, 19 Jan 2005 21:03:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:subject:date:mime-version:content-type:x-mailer:thread-index:x-mimeole:message-id; b=jyRd1Xm13Ljpv/mA4ALNsMXf3lzeS/N5Sf8WVnpdeasGaAc17aZ3CnS2FRGE9YU/KBYHoTV+jxOkhs52ML8qhEl+fu3M4qYWc91n6eZD1jQxJrYCL/hV79b9nvzz4ANxsxRBl+SbDfyGQiopn7T86k7CbMe+WkvH01Z0s1TfTSw= Received: by 10.38.90.8 with SMTP id n8mr202248rnb; Wed, 19 Jan 2005 21:03:36 -0800 (PST) Received: from athena ([24.34.183.155]) by smtp.gmail.com with ESMTP id 74sm2338rnb.2005.01.19.21.03.35; Wed, 19 Jan 2005 21:03:36 -0800 (PST) From: "Troyston Campano" To: , Subject: Oracle and Postgresql Play Nice Together on Same Computer? Date: Thu, 20 Jan 2005 00:03:28 -0500 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C4FE83.791385F0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcT+rWEeXwS47tgdTzSFSnTf3gLSzw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-ID: <41ef3ba8.6eecd830.614a.0054@smtp.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.052 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/204 X-Sequence-Number: 16063 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C4FE83.791385F0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the large corporation where I work to test the benefits of using Postgresql in our environment. I want to install Postgresql onto a "production" server that currently runs Oracle. Are there any problems with running Postgresql and Oracle on the same machine? I mean, I've heard that the way Sybase and DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is installed on the same machine as the Sybase Server (something about UDB eating up all the memory and not giving it back to Sybase). Are there any issues running Postgresql and Oracle on the same machine.anything special to know about memory, disk layout, and things like that? I just want to make sure the two engines play together on this same server. I had a hard time finding information about this via google. Thank you for your time! ~ Troyston ~ ------=_NextPart_000_0007_01C4FE83.791385F0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

I am an Oracle DBA and I want do a Postgresql = ‘proof of concept’ at the large corporation where I work to test the = benefits of using Postgresql in our environment. I want to install Postgresql onto a = “production” server that currently runs Oracle. Are there any problems with running Postgresql and Oracle on the same machine? I mean, I’ve heard that = the way Sybase and DB2 UDB are architected to handle memory hurts Sybase = when DB2 UDB is installed on the same machine as the Sybase Server (something = about UDB eating up all the memory and not giving it back to = Sybase).

 

Are there any issues running Postgresql and Oracle on = the same machine…anything special to know about memory, disk layout, = and things like that? I just want to make sure the two engines play together = on this same server. I had a hard time finding information about this via = google.

 

Thank you for your time!

 

~ Troyston ~

------=_NextPart_000_0007_01C4FE83.791385F0-- From barwick@gmail.com Thu Jan 20 08:06:50 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B0F93A46F4 for ; Thu, 20 Jan 2005 08:06:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47388-05 for ; Thu, 20 Jan 2005 08:06:44 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by svr1.postgresql.org (Postfix) with ESMTP id CE8083A46CC for ; Thu, 20 Jan 2005 08:06:44 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 50so99961wri for ; Thu, 20 Jan 2005 00:06:44 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=paJLmzCGbNv44S1n4RNdzc3tFFxxrvSyXKxzCtoXXN8cbsyb0xhVaG4pCxBmss7LMpyQhAclDdou06/X+LTqtluglVthmmwWDEw79YAPzF7LzCJFz+ZHF9UoZlFDX3njLv4VL4s9rjqok0qSIC5jzIPNH25A+jB1yfDS/zy+5Ug= Received: by 10.54.16.5 with SMTP id 5mr42443wrp; Thu, 20 Jan 2005 00:06:44 -0800 (PST) Received: by 10.54.5.58 with HTTP; Thu, 20 Jan 2005 00:06:44 -0800 (PST) Message-ID: <1d581afe05012000067864ca78@mail.gmail.com> Date: Thu, 20 Jan 2005 09:06:44 +0100 From: Ian Barwick Reply-To: Ian Barwick To: Troyston Campano Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer? Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org In-Reply-To: <41ef3ba8.6eecd830.614a.0054@smtp.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable References: <41ef3ba8.6eecd830.614a.0054@smtp.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.027 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/209 X-Sequence-Number: 16068 On Thu, 20 Jan 2005 00:03:28 -0500, Troyston Campano wrote: >=20 > Hello,=20 >=20 > I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the > large corporation where I work to test the benefits of using Postgresql i= n > our environment. I want to install Postgresql onto a "production" server > that currently runs Oracle. Are there any problems with running Postgresq= l > and Oracle on the same machine? I mean, I've heard that the way Sybase an= d > DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is > installed on the same machine as the Sybase Server (something about UDB > eating up all the memory and not giving it back to Sybase).=20 >=20 > Are there any issues running Postgresql and Oracle on the same > machine=E2=80=A6anything special to know about memory, disk layout, and t= hings like > that? I just want to make sure the two engines play together on this same > server. I had a hard time finding information about this via google.=20 For testing purposes there shouldn't be any problems, at least in a *NIX environment. PostgreSQL is very undemanding and compared to Oracle is positively minuscule (at least as far as its "installation footprint" goes). I've run PostgreSQL, MySQL, DB2 and Oracle on the same development machine without any issues. Of course if another application is in constant use on a production server PostgreSQL won't perform as well as it could. Ian Barwick From simon@2ndquadrant.com Thu Jan 20 09:22:18 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6560A3A3D7D; Thu, 20 Jan 2005 09:22:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59967-02; Thu, 20 Jan 2005 09:22:06 +0000 (GMT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.177]) by svr1.postgresql.org (Postfix) with ESMTP id 9A7E63A4476; Thu, 20 Jan 2005 09:22:06 +0000 (GMT) Received: from [212.227.126.203] (helo=mrvnet.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1CrYVu-0003OH-00; Thu, 20 Jan 2005 10:22:02 +0100 Received: from [172.23.4.146] (helo=config19.kundenserver.de) by mrvnet.kundenserver.de with esmtp (Exim 3.35 #1) id 1CrYVu-00006X-00; Thu, 20 Jan 2005 10:22:02 +0100 Received: from www-data by config19.kundenserver.de with local (Exim 3.35 #1 (Debian)) id 1CrYVu-0003Mg-00; Thu, 20 Jan 2005 10:22:02 +0100 To: =?iso-8859-1?Q?Troyston_Campano?= Subject: =?iso-8859-1?Q?Re:__Oracle_and_Postgresql_Play_Nice_Together_on_Same_Computer??= From: Cc: , Message-Id: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> X-Binford: 6100 (more power) X-Originating-From: 28292295 X-Mailer: Webmail X-Routing: UK X-Received: from config19 by 193.114.111.34 with HTTP id 28292295 for troygeekdatabase@gmail.com; Thu, 20 Jan 2005 10:20:02 +0100 Content-Type: text/plain; charset="iso-8859-1" Mime-Version: 1.0 Content-Transfer-Encoding: 8bit X-Priority: 3 Date: Thu, 20 Jan 2005 10:20:02 +0100 X-Provags-ID: kundenserver.de abuse@kundenserver.de ident:@172.23.4.146 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.425 tagged_above=0 required=5 tests=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/211 X-Sequence-Number: 16070 Troyston Campano wrote on 20.01.2005, 06:03:28: > I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the > large corporation where I work to test the benefits of using Postgresql in > our environment. I want to install Postgresql onto a "production" server > that currently runs Oracle. Are there any problems with running Postgresql > and Oracle on the same machine? I mean, I've heard that the way Sybase and > DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is > installed on the same machine as the Sybase Server (something about UDB > eating up all the memory and not giving it back to Sybase). > > > > Are there any issues running Postgresql and Oracle on the same > machine.anything special to know about memory, disk layout, and things like > that? I just want to make sure the two engines play together on this same > server. I had a hard time finding information about this via google. > There should be no issues running both on the same machine. Running both together at the same time isn't a good way of doing a benchmark though... I would question your intent slightly. Should it be a relative comparison? Or should it be an assessment of what PostgreSQL is capable of and whether that fits a sufficient number of your needs to make it worth adopting? There are many ways to structure a decision as to whether PostgreSQL is suitable for your (business?) needs. Which structure you choose is likely to prejudice your decision, one way or the other. i.e. if capital acquisition costs are the decising factor, then PostgreSQL would always win. Best Regards, Simon Riggs From pgsql@esiway.net Thu Jan 20 11:45:06 2005 X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 418013A45C7 for ; Thu, 20 Jan 2005 11:45:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84229-02 for ; Thu, 20 Jan 2005 11:44:43 +0000 (GMT) Received: from Nazgul.esiway.net (Nazgul.ESIWAY.NET [193.194.16.154]) by svr1.postgresql.org (Postfix) with ESMTP id 6388C3A1D6B for ; Thu, 20 Jan 2005 11:44:44 +0000 (GMT) Received: from Megathlon.ESI (Ghost.esi.it [193.194.16.225]) by Nazgul.esiway.net (8.13.1/8.13.1) with ESMTP id j0KBiV6p027743 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL); Thu, 20 Jan 2005 12:44:31 +0100 Received: from relay.ESI (relay.ESI [10.10.10.3]) (user=marco mech=CRAM-MD5 bits=0) by Megathlon.ESI (8.12.11/8.12.11) with ESMTP id j0KBieuO022503 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 20 Jan 2005 12:44:40 +0100 Date: Thu, 20 Jan 2005 12:44:40 +0100 (CET) From: Marco Colombo X-X-Sender: marco@Megathlon.ESI To: simon@2ndquadrant.com Cc: pgsql-general@postgresql.org Subject: Re: =?iso-8859-1?Q?Re:_[ADMIN]_Oracle_and_Postgresql_Play_Nice_Together_on_Same_Computer??= In-Reply-To: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> Message-ID: References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/1062 X-Sequence-Number: 72011 On Thu, 20 Jan 2005 simon@2ndquadrant.com wrote: > > Troyston Campano wrote on 20.01.2005, > 06:03:28: >> I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the >> large corporation where I work to test the benefits of using Postgresql in >> our environment. I want to install Postgresql onto a "production" server >> that currently runs Oracle. Are there any problems with running Postgresql >> and Oracle on the same machine? I mean, I've heard that the way Sybase and >> DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is >> installed on the same machine as the Sybase Server (something about UDB >> eating up all the memory and not giving it back to Sybase). >> >> >> >> Are there any issues running Postgresql and Oracle on the same >> machine.anything special to know about memory, disk layout, and things like >> that? I just want to make sure the two engines play together on this same >> server. I had a hard time finding information about this via google. >> > > There should be no issues running both on the same machine. Running both > together at the same time isn't a good way of doing a benchmark > though... > > I would question your intent slightly. Should it be a relative > comparison? Or should it be an assessment of what PostgreSQL is capable > of and whether that fits a sufficient number of your needs to make it > worth adopting? > > There are many ways to structure a decision as to whether PostgreSQL is > suitable for your (business?) needs. Which structure you choose is > likely to prejudice your decision, one way or the other. i.e. if > capital acquisition costs are the decising factor, then PostgreSQL > would always win. I may add that using the right tool for the right task should be a priority. It's easy to underestimate the cost of continuosly adapting your needs to the tool and not the opposite. About Oracle I keep hearing success or horror stories. About PostgreSQL mostly success stories, some unsuccess stories ("it's good but we switched back to MS SQL" ), _very_ few horror stories. Last horror story was about "data worth having but not backupping", a category existing only in some manager's mind (and _deserving_ a horror story). Note that I've never heard any unsuccess story about Oracle. I know some people that would tell one, if only they actually tried PostgreSQL out - but that's my opinion, not thiers (yet). IMHO, migrating from Oracle to PostgreSQL usually doesn't expose all PostgreSQL pros, and will expose some weaknesses or missing features. Migrating from PostgreSQL to Oracle is what really makes PostgreSQL shine. Too bad it happens so rarely. :-) .TM. -- ____/ ____/ / / / / Marco Colombo ___/ ___ / / Technical Manager / / / ESI s.r.l. _____/ _____/ _/ Colombo@ESI.it From troygeekdatabase@gmail.com Thu Jan 20 12:58:23 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3E2083A2C43 for ; Thu, 20 Jan 2005 12:58:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91045-03 for ; Thu, 20 Jan 2005 12:58:14 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.204]) by svr1.postgresql.org (Postfix) with ESMTP id DEAF23A4730 for ; Thu, 20 Jan 2005 12:58:13 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id b11so3576rne for ; Thu, 20 Jan 2005 04:58:12 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:cc:subject:date:mime-version:content-type:x-mailer:in-reply-to:x-mimeole:thread-index:message-id; b=AauAunXn4y/X/GMJXaLJcfmQurHr4Fg1+P+0riZ/AHibuThKCQ5EWVEFEeXjcTXgPta27Ec3EqAHmHu4N+4akkdIbq+TaXanX3r5veN64BZ/t9nSItL8y6s1nGPk6pdtbxhqoyqdzcdq0OYAYGAdEpDomv+A83fXeORMf5tbyr0= Received: by 10.38.4.61 with SMTP id 61mr17381rnd; Thu, 20 Jan 2005 04:58:11 -0800 (PST) Received: from athena ([24.34.183.155]) by smtp.gmail.com with ESMTP id 63sm5324rna.2005.01.20.04.58.11; Thu, 20 Jan 2005 04:58:11 -0800 (PST) From: "Troyston Campano" To: , Cc: "'Ian Barwick'" Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer? Date: Thu, 20 Jan 2005 07:58:04 -0500 Mime-Version: 1.0 Content-Type: text/plain; X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <1d581afe05012000067864ca78@mail.gmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 thread-index: AcT+xvrsYyyOZqQUSd+Xm2ycp2nW+gAKA+Bw Message-ID: <41efaae3.39b41852.390e.00a8@smtp.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/214 X-Sequence-Number: 16073 I guess what I am concerned about *is* running on a production server more than a test server. Basically, I'd be taking a couple applications that are running on the Oracle database instance, building a Postgresql instance, and migrating them to that postgresql database instance. I'm just wondering whether it's a bad idea to run them on the same server machine in a production environment. (So instead of having 10 applications running on Oracle on ServerComputerA...build a new postgresql instance on ServerComputerA that lives along with Oracle and migrating 3 of the applications to Postgresql. Thank you for your time! ~ Troyston Campano ~ -----Original Message----- From: Ian Barwick [mailto:barwick@gmail.com] Sent: Thursday, January 20, 2005 3:07 AM To: Troyston Campano Cc: pgsql-admin@postgresql.org; pgsql-general@postgresql.org Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer? On Thu, 20 Jan 2005 00:03:28 -0500, Troyston Campano wrote: > > Hello, > > I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the > large corporation where I work to test the benefits of using Postgresql in > our environment. I want to install Postgresql onto a "production" server > that currently runs Oracle. Are there any problems with running Postgresql > and Oracle on the same machine? I mean, I've heard that the way Sybase and > DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is > installed on the same machine as the Sybase Server (something about UDB > eating up all the memory and not giving it back to Sybase). > > Are there any issues running Postgresql and Oracle on the same > machine.anything special to know about memory, disk layout, and things like > that? I just want to make sure the two engines play together on this same > server. I had a hard time finding information about this via google. For testing purposes there shouldn't be any problems, at least in a *NIX environment. PostgreSQL is very undemanding and compared to Oracle is positively minuscule (at least as far as its "installation footprint" goes). I've run PostgreSQL, MySQL, DB2 and Oracle on the same development machine without any issues. Of course if another application is in constant use on a production server PostgreSQL won't perform as well as it could. Ian Barwick From troygeekdatabase@gmail.com Thu Jan 20 13:03:59 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 16EFB3A474C for ; Thu, 20 Jan 2005 13:03:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90978-09 for ; Thu, 20 Jan 2005 13:03:51 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id 4993D3A2B8D for ; Thu, 20 Jan 2005 13:03:52 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id f1so4283rne for ; Thu, 20 Jan 2005 05:03:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:cc:subject:date:mime-version:content-type:x-mailer:in-reply-to:x-mimeole:thread-index:message-id; b=AsuGL+2cxZ7utLES4DA5BmVeMB8hjmQ3cgG6A8AqOcK6BAFGtfK0J60e1MJ9SHL4LMtW/yPpOynxXjJNv9IxlltMiDfSFIyXgp7zMLJAipZPeUJs04jzp3cMyyp3BDCDgBe3e4bUsDIx8OmXSvE2UTcPBtSasFlD+jy/65YMFFQ= Received: by 10.38.125.50 with SMTP id x50mr117196rnc; Thu, 20 Jan 2005 05:03:49 -0800 (PST) Received: from athena ([24.34.183.155]) by smtp.gmail.com with ESMTP id 71sm6157rnc.2005.01.20.05.03.49; Thu, 20 Jan 2005 05:03:49 -0800 (PST) From: "Troyston Campano" To: Cc: , Subject: Re: Oracle and Postgresql Play Nice Together on Same Computer? Date: Thu, 20 Jan 2005 08:03:42 -0500 Mime-Version: 1.0 Content-Type: text/plain; X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 thread-index: AcT+0YB1A75BQ+H6TLy3B4Nj+ZW6iQAHrV3Q Message-ID: <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.033 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/215 X-Sequence-Number: 16074 Basically, we want to take 3 of the 10 applications running on Oracle, move them to Postgresql on the same computer/server and just make sure it runs about the same (really speed, memory usage, and space are the big issues). I'm not concerned with how hard the migration will be and things like that. The database is very low in complexity so the migration should be cake. Thank you! -----Original Message----- From: simon@2ndquadrant.com [mailto:simon@2ndquadrant.com] Sent: Thursday, January 20, 2005 4:20 AM To: Troyston Campano Cc: pgsql-admin@postgresql.org; pgsql-general@postgresql.org Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer? Troyston Campano wrote on 20.01.2005, 06:03:28: > I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the > large corporation where I work to test the benefits of using Postgresql in > our environment. I want to install Postgresql onto a "production" server > that currently runs Oracle. Are there any problems with running Postgresql > and Oracle on the same machine? I mean, I've heard that the way Sybase and > DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is > installed on the same machine as the Sybase Server (something about UDB > eating up all the memory and not giving it back to Sybase). > > > > Are there any issues running Postgresql and Oracle on the same > machine.anything special to know about memory, disk layout, and things like > that? I just want to make sure the two engines play together on this same > server. I had a hard time finding information about this via google. > There should be no issues running both on the same machine. Running both together at the same time isn't a good way of doing a benchmark though... I would question your intent slightly. Should it be a relative comparison? Or should it be an assessment of what PostgreSQL is capable of and whether that fits a sufficient number of your needs to make it worth adopting? There are many ways to structure a decision as to whether PostgreSQL is suitable for your (business?) needs. Which structure you choose is likely to prejudice your decision, one way or the other. i.e. if capital acquisition costs are the decising factor, then PostgreSQL would always win. Best Regards, Simon Riggs From alvherre@dcc.uchile.cl Thu Jan 20 13:42:20 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A0803A4110; Thu, 20 Jan 2005 13:42:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96517-05; Thu, 20 Jan 2005 13:42:13 +0000 (GMT) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4C0CE3A4779; Thu, 20 Jan 2005 13:42:06 +0000 (GMT) Received: from anakena.dcc.uchile.cl ([192.80.24.3]) by sunsite.dcc.uchile.cl (8.12.11/8.12.11) with ESMTP id j0KDfuvJ016072; Thu, 20 Jan 2005 10:41:56 -0300 (CLST) Received: by anakena.dcc.uchile.cl (Postfix, from userid 4151) id 396B0524AC; Thu, 20 Jan 2005 10:41:56 -0300 (CLST) Date: Thu, 20 Jan 2005 10:41:56 -0300 From: Alvaro Herrera To: Troyston Campano Cc: simon@2ndquadrant.com, pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer? Message-ID: <20050120134156.GA16939@dcc.uchile.cl> References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.338 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200501/217 X-Sequence-Number: 16076 On Thu, Jan 20, 2005 at 08:03:42AM -0500, Troyston Campano wrote: > Basically, we want to take 3 of the 10 applications running on Oracle, move > them to Postgresql on the same computer/server and just make sure it runs > about the same (really speed, memory usage, and space are the big issues). > I'm not concerned with how hard the migration will be and things like that. So you want Postgres to be a cheaper Oracle. Hmm. Maybe it will work, but as Marco Colombo says, you are not going to see Postgres shining by using that simplistic approach. If you want that, maybe you should look closely to see where you can find the rusty corner that needs to be polished. > The database is very low in complexity so the migration should be cake. If you do things as simple as "select count(*) from table", then you will have to be careful to be really fair in your comparison; you could misleadingly find that Postgres is much slower on that query. -- Alvaro Herrera () Tulio: oh, para qué servirá este boton, Juan Carlos? Policarpo: No, aléjense, no toquen la consola! Juan Carlos: Lo apretaré una y otra vez. From pgsql@esiway.net Thu Jan 20 14:22:48 2005 X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 02F5E3A46CF for ; Thu, 20 Jan 2005 14:22:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06278-06 for ; Thu, 20 Jan 2005 14:22:41 +0000 (GMT) Received: from Nazgul.esiway.net (Nazgul.ESIWAY.NET [193.194.16.154]) by svr1.postgresql.org (Postfix) with ESMTP id 7CD883A18CF for ; Thu, 20 Jan 2005 14:22:42 +0000 (GMT) Received: from Megathlon.ESI (Ghost.esi.it [193.194.16.225]) by Nazgul.esiway.net (8.13.1/8.13.1) with ESMTP id j0KEMO8f007941 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL); Thu, 20 Jan 2005 15:22:24 +0100 Received: from relay.ESI (relay.ESI [10.10.10.3]) (user=marco mech=CRAM-MD5 bits=0) by Megathlon.ESI (8.12.11/8.12.11) with ESMTP id j0KEMXg8026636 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 20 Jan 2005 15:22:33 +0100 Date: Thu, 20 Jan 2005 15:22:33 +0100 (CET) From: Marco Colombo X-X-Sender: marco@Megathlon.ESI To: Alvaro Herrera Cc: pgsql-general@postgresql.org Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer? In-Reply-To: <20050120134156.GA16939@dcc.uchile.cl> Message-ID: References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> <20050120134156.GA16939@dcc.uchile.cl> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/1080 X-Sequence-Number: 72029 [ Cc: list cleaned a bit ] On Thu, 20 Jan 2005, Alvaro Herrera wrote: > On Thu, Jan 20, 2005 at 08:03:42AM -0500, Troyston Campano wrote: >> Basically, we want to take 3 of the 10 applications running on Oracle, move >> them to Postgresql on the same computer/server and just make sure it runs >> about the same (really speed, memory usage, and space are the big issues). >> I'm not concerned with how hard the migration will be and things like that. > > So you want Postgres to be a cheaper Oracle. Hmm. Maybe it will work, > but as Marco Colombo says, you are not going to see Postgres shining by > using that simplistic approach. If you want that, maybe you should look > closely to see where you can find the rusty corner that needs to be > polished. > >> The database is very low in complexity so the migration should be cake. > > If you do things as simple as "select count(*) from table", then you > will have to be careful to be really fair in your comparison; you could > misleadingly find that Postgres is much slower on that query. Yeah, that's precisely what I meant. The Oracle to PostgreSQL migration is well worth considering a (partial) redesign. Sometimes I happen to show some SQL queries I make (on PostgreSQL) to an Oracle guy. Usually it goes like this: 1) hmm (ponders at the query) 2) ah!!! (realizes what the query does) 3) I didn't know you could do this! (excitement) 4) hmm (ponders again if that may work on Oracle as well) 5) no I can't do that in Oracle that way. I remember I did something like that in the past with other 3 SQL developers. We had to write a 300 lines long stored procedure, we got the locking right at the third reimplementation only (we don't know if we do need the locking, we asked our senior DBA but he was unsure as well, so we put it in, we don't think it hurts anyway). Ok, point 5) has been exaggerated to joke level, but you get the idea. .TM. -- ____/ ____/ / / / / Marco Colombo ___/ ___ / / Technical Manager / / / ESI s.r.l. _____/ _____/ _/ Colombo@ESI.it From troygeekdatabase@gmail.com Thu Jan 20 15:50:26 2005 X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 01D4C3A4807 for ; Thu, 20 Jan 2005 15:50:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18022-01 for ; Thu, 20 Jan 2005 15:50:06 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.197]) by svr1.postgresql.org (Postfix) with ESMTP id DB2533A18CF for ; Thu, 20 Jan 2005 15:50:06 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 50so147116wri for ; Thu, 20 Jan 2005 07:50:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=r8G4RutFrYAhUgd7Pt13X7ZAlYZp7z7FCKSA1RkppTKIe1ovcT7DaAzxYPRXS6JnikMu0JPPal4yxr8ZeHiS98MNGZ2K48Lyzf+EnXhsOkgXk0D5Lrcnb+48sqMbf2izeso0xyme4Rdc29auoL1ShkGW62v8sXFVKDwOayWY5hc= Received: by 10.54.5.65 with SMTP id 65mr269261wre; Thu, 20 Jan 2005 07:50:06 -0800 (PST) Received: by 10.54.52.58 with HTTP; Thu, 20 Jan 2005 07:50:06 -0800 (PST) Message-ID: Date: Thu, 20 Jan 2005 10:50:06 -0500 From: troyston campano Reply-To: troyston campano To: pgsql-general@postgresql.org Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer? Cc: Marco Colombo In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> <20050120134156.GA16939@dcc.uchile.cl> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/1084 X-Sequence-Number: 72033 I'm not really too concerned about the migration aspect at all. If need be, we might even throw in some new applications into the postgresql database. What we're really concerned about is any issues that may come from running postgresql and oracle on the same box. Do they play nice together...or does one hog memory in a way that prevents the other engine from operating correctly? I'm worried more about things like that. thank you again for your time! ~ Troyston ~ On Thu, 20 Jan 2005 15:22:33 +0100 (CET), Marco Colombo wrote: > [ Cc: list cleaned a bit ] > > On Thu, 20 Jan 2005, Alvaro Herrera wrote: > > > On Thu, Jan 20, 2005 at 08:03:42AM -0500, Troyston Campano wrote: > >> Basically, we want to take 3 of the 10 applications running on Oracle, move > >> them to Postgresql on the same computer/server and just make sure it runs > >> about the same (really speed, memory usage, and space are the big issues). > >> I'm not concerned with how hard the migration will be and things like that. > > > > So you want Postgres to be a cheaper Oracle. Hmm. Maybe it will work, > > but as Marco Colombo says, you are not going to see Postgres shining by > > using that simplistic approach. If you want that, maybe you should look > > closely to see where you can find the rusty corner that needs to be > > polished. > > > >> The database is very low in complexity so the migration should be cake. > > > > If you do things as simple as "select count(*) from table", then you > > will have to be careful to be really fair in your comparison; you could > > misleadingly find that Postgres is much slower on that query. > > Yeah, that's precisely what I meant. The Oracle to PostgreSQL migration > is well worth considering a (partial) redesign. > > Sometimes I happen to show some SQL queries I make (on PostgreSQL) > to an Oracle guy. Usually it goes like this: > > 1) hmm (ponders at the query) > 2) ah!!! (realizes what the query does) > 3) I didn't know you could do this! (excitement) > 4) hmm (ponders again if that may work on Oracle as well) > 5) no I can't do that in Oracle that way. I remember I did something > like that in the past with other 3 SQL developers. We had to write > a 300 lines long stored procedure, we got the locking right at the > third reimplementation only (we don't know if we do need the locking, > we asked our senior DBA but he was unsure as well, so we put it in, > we don't think it hurts anyway). > > Ok, point 5) has been exaggerated to joke level, but you get the idea. > > .TM. > -- > ____/ ____/ / > / / / Marco Colombo > ___/ ___ / / Technical Manager > / / / ESI s.r.l. > _____/ _____/ _/ Colombo@ESI.it > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > From fde101@fjrhome.net Thu Jan 20 16:09:13 2005 X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B78873A4872 for ; Thu, 20 Jan 2005 16:09:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20343-06 for ; Thu, 20 Jan 2005 16:09:09 +0000 (GMT) Received: from fjrhome.net (dpmail01.doteasy.com [65.61.209.1]) by svr1.postgresql.org (Postfix) with ESMTP id 474BF3A4860 for ; Thu, 20 Jan 2005 16:09:08 +0000 (GMT) Received: from [192.168.0.202] [141.158.181.54] by fjrhome.net with ESMTP (SMTPD32-8.05) id A7288219011E; Thu, 20 Jan 2005 08:07:04 -0800 Mime-Version: 1.0 (Apple Message framework v619) In-Reply-To: References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> <41efac35.405152b6.2a2f.00d1@smtp.gmail.com> <20050120134156.GA16939@dcc.uchile.cl> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <9A2A5356-6AFD-11D9-AAA7-0050E410655F@fjrhome.net> Content-Transfer-Encoding: 7bit From: "Frank D. Engel, Jr." Subject: Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer? Date: Thu, 20 Jan 2005 11:09:02 -0500 To: 'PgSql General' X-Pgp-Agent: GPGMail 1.0.2 X-Mailer: Apple Mail (2.619) X-IMSTrailer: __IMail_7__ X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.566 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200501/1088 X-Sequence-Number: 72037 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Does anyone know if there could be a shared memory issue here? If there is, then one of the two (postgres or oracle) would simply refuse to start (it would quit with an error, I'd assume). If this happens, you would need to either decrease the number of shared memory resources one database or the other is asking for, or increase the number of shared memory resources made available by the kernel (the exact process depends on your operating system; I forget if you named the one you are using or not). Otherwise, there shouldn't be a problem, as long as your server hardware has the resources to handle both at the same time (disk space, memory/CPU power, etc.) On Jan 20, 2005, at 10:50 AM, troyston campano wrote: > I'm not really too concerned about the migration aspect at all. If > need be, we might even throw in some new applications into the > postgresql database. What we're really concerned about is any issues > that may come from running postgresql and oracle on the same box. Do > they play nice together...or does one hog memory in a way that > prevents the other engine from operating correctly? I'm worried more > about things like that. > > thank you again for your time! > > ~ Troyston ~ > > > On Thu, 20 Jan 2005 15:22:33 +0100 (CET), Marco Colombo > wrote: >> [ Cc: list cleaned a bit ] >> >> On Thu, 20 Jan 2005, Alvaro Herrera wrote: >> >>> On Thu, Jan 20, 2005 at 08:03:42AM -0500, Troyston Campano wrote: >>>> Basically, we want to take 3 of the 10 applications running on >>>> Oracle, move >>>> them to Postgresql on the same computer/server and just make sure >>>> it runs >>>> about the same (really speed, memory usage, and space are the big >>>> issues). >>>> I'm not concerned with how hard the migration will be and things >>>> like that. >>> >>> So you want Postgres to be a cheaper Oracle. Hmm. Maybe it will >>> work, >>> but as Marco Colombo says, you are not going to see Postgres shining >>> by >>> using that simplistic approach. If you want that, maybe you should >>> look >>> closely to see where you can find the rusty corner that needs to be >>> polished. >>> >>>> The database is very low in complexity so the migration should be >>>> cake. >>> >>> If you do things as simple as "select count(*) from table", then you >>> will have to be careful to be really fair in your comparison; you >>> could >>> misleadingly find that Postgres is much slower on that query. >> >> Yeah, that's precisely what I meant. The Oracle to PostgreSQL >> migration >> is well worth considering a (partial) redesign. >> >> Sometimes I happen to show some SQL queries I make (on PostgreSQL) >> to an Oracle guy. Usually it goes like this: >> >> 1) hmm (ponders at the query) >> 2) ah!!! (realizes what the query does) >> 3) I didn't know you could do this! (excitement) >> 4) hmm (ponders again if that may work on Oracle as well) >> 5) no I can't do that in Oracle that way. I remember I did something >> like that in the past with other 3 SQL developers. We had to write >> a 300 lines long stored procedure, we got the locking right at the >> third reimplementation only (we don't know if we do need the >> locking, >> we asked our senior DBA but he was unsure as well, so we put it in, >> we don't think it hurts anyway). >> >> Ok, point 5) has been exaggerated to joke level, but you get the idea. >> >> .TM. >> -- >> ____/ ____/ / >> / / / Marco Colombo >> ___/ ___ / / Technical Manager >> / / / ESI s.r.l. >> _____/ _____/ _/ Colombo@ESI.it >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org >> > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > - ----------------------------------------------------------- Frank D. Engel, Jr. $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep "John 3:16" John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life. $ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Darwin) iD8DBQFB79ef7aqtWrR9cZoRAvdMAJwKW+dptxX+zPv5Ql1XUbzPDZGvywCaAqpN ghnwgW9m1Qtcb/QBqWzpGf0= =d65G -----END PGP SIGNATURE----- ___________________________________________________________ $0 Web Hosting with up to 120MB web space, 1000 MB Transfer 10 Personalized POP and Web E-mail Accounts, and much more. Signup at www.doteasy.com From armtuk@gmail.com Thu Jan 20 16:23:06 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D43C43A484B for ; Thu, 20 Jan 2005 16:23:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22505-02 for ; Thu, 20 Jan 2005 16:23:02 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.195]) by svr1.postgresql.org (Postfix) with ESMTP id 3113D3A4838 for ; Thu, 20 Jan 2005 16:23:01 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 50so152638wri for ; Thu, 20 Jan 2005 08:23:00 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=SDC/xUqKFPuSNX9NYGQj2ThbuG0JIVjNtsN6iIANra3P51X5mwPI9aTmgIfOU7aiywrzSihqE8XnVOK1gQ6J2Z0AJzdmFF57HXmxzeSnZtrhH6siEYGZtUBGeTjbYvakjtFgGR7i+Ad/NZWbrA/TDgiVg5NcSk0bSym6Sif64Lg= Received: by 10.54.16.71 with SMTP id 71mr24204wrp; Thu, 20 Jan 2005 08:23:00 -0800 (PST) Received: by 10.54.18.72 with HTTP; Thu, 20 Jan 2005 08:23:00 -0800 (PST) Message-ID: <33c6269f05012008231cde4663@mail.gmail.com> Date: Thu, 20 Jan 2005 11:23:00 -0500 From: Alex Turner Reply-To: alex@neteconomist.com To: "simon@2ndquadrant.com" Subject: Re: [GENERAL] Re: Oracle and Postgresql Play Nice Together on Same Computer Cc: Troyston Campano , pgsql-admin@postgresql.org, pgsql-general@postgresql.org In-Reply-To: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <28292295$110621206841ef74e4819f47.82018906@config19.schlund.de> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.265 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP, TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200501/218 X-Sequence-Number: 16077 It depends how you have your Oracle instance configured. If you have it set up so that the total SGA and UGA ammount consume around 80%-90% of total available memory, then this is obviously only going to leave postgress with 20% or less of the total available memory. Postgres is also designed to take advantage of the file caching behaviour of the OS. The OS however is probably going to prioritize Oracle running memory over cached file pages, and therefore I would think that running the two together is a less than optimal configuration. If you are going to do it, I would make sure that you at least reduce the SGA for Oracle down below 40% of the box's total RAM so you give postgresql enough space to work in. Even doing this, there is a chance that the OS will try to cache the Oracle Tablespace files if they are small enough, duplicating the buffering effort that Oracle is doing, and also reducing the amount of memory for Postgresql file cache. All in all, I would personaly be very wary of running both together if you are planning on doing any benchmarking. Alex Turner NetEconomist On Thu, 20 Jan 2005 10:20:02 +0100, simon@2ndquadrant.com wrote: > > Troyston Campano wrote on 20.01.2005, > 06:03:28: > > I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the > > large corporation where I work to test the benefits of using Postgresql in > > our environment. I want to install Postgresql onto a "production" server > > that currently runs Oracle. Are there any problems with running Postgresql > > and Oracle on the same machine? I mean, I've heard that the way Sybase and > > DB2 UDB are architected to handle memory hurts Sybase when DB2 UDB is > > installed on the same machine as the Sybase Server (something about UDB > > eating up all the memory and not giving it back to Sybase). > > > > > > > > Are there any issues running Postgresql and Oracle on the same > > machine.anything special to know about memory, disk layout, and things like > > that? I just want to make sure the two engines play together on this same > > server. I had a hard time finding information about this via google. > > > > There should be no issues running both on the same machine. Running both > together at the same time isn't a good way of doing a benchmark > though... > > I would question your intent slightly. Should it be a relative > comparison? Or should it be an assessment of what PostgreSQL is capable > of and whether that fits a sufficient number of your needs to make it > worth adopting? > > There are many ways to structure a decision as to whether PostgreSQL is > suitable for your (business?) needs. Which structure you choose is > likely to prejudice your decision, one way or the other. i.e. if > capital acquisition costs are the decising factor, then PostgreSQL > would always win. > > Best Regards, Simon Riggs > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > From smarlowe@g2switchworks.com Thu Jan 20 16:30:53 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5148C3A4884; Thu, 20 Jan 2005 16:30:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22965-08; Thu, 20 Jan 2005 16:30:49 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 8A0403A4886; Thu, 20 Jan 2005 16:30:49 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 20 Jan 2005 10:30:48 -0600 Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same From: Scott Marlowe To: Troyston Campano Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org In-Reply-To: <41ef3ba8.6eecd830.614a.0054@smtp.gmail.com> References: <41ef3ba8.6eecd830.614a.0054@smtp.gmail.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1106238648.16640.13.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 20 Jan 2005 10:30:48 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/219 X-Sequence-Number: 16078 On Wed, 2005-01-19 at 23:03, Troyston Campano wrote: > Hello,=20 >=20 > I am an Oracle DBA and I want do a Postgresql =E2=80=98proof of concept= =E2=80=99 at > the large corporation where I work to test the benefits of using > Postgresql in our environment. I want to install Postgresql onto a > =E2=80=9Cproduction=E2=80=9D server that currently runs Oracle. Are there= any problems > with running Postgresql and Oracle on the same machine? I mean, I=E2=80= =99ve > heard that the way Sybase and DB2 UDB are architected to handle memory > hurts Sybase when DB2 UDB is installed on the same machine as the > Sybase Server (something about UDB eating up all the memory and not > giving it back to Sybase). >=20 > =20 >=20 > Are there any issues running Postgresql and Oracle on the same > machine=E2=80=A6anything special to know about memory, disk layout, and t= hings > like that? I just want to make sure the two engines play together on > this same server. I had a hard time finding information about this via > google. The only issue you're likely to face is the one you've already mentioned, that Oracle may be configured to use most of the memory on the machine, and PostgreSQL, in general, relies on the OS to do the caching for it. Since there might not be much free / cache memory on the machine, PostgreSQL may run a bit slower than it would were it the only thing on the machine. However, you can always do a benchmark with Oracle running, then shut down oracle for a few minutes and see if PostgreSQL runs any faster with the extra memory being used by the OS to cache the dataset. From smarlowe@g2switchworks.com Thu Jan 20 16:39:34 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6336D3A486B; Thu, 20 Jan 2005 16:39:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25515-09; Thu, 20 Jan 2005 16:39:30 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 5307C3A48A8; Thu, 20 Jan 2005 16:39:29 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 20 Jan 2005 10:39:29 -0600 Subject: Re: [GENERAL] Oracle and Postgresql Play Nice Together on From: Scott Marlowe To: Troyston Campano Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org, 'Ian Barwick' In-Reply-To: <41efaae3.39b41852.390e.00a8@smtp.gmail.com> References: <41efaae3.39b41852.390e.00a8@smtp.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1106239169.16640.18.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 20 Jan 2005 10:39:29 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/220 X-Sequence-Number: 16079 On Thu, 2005-01-20 at 06:58, Troyston Campano wrote: > I guess what I am concerned about *is* running on a production server more > than a test server. Basically, I'd be taking a couple applications that are > running on the Oracle database instance, building a Postgresql instance, and > migrating them to that postgresql database instance. I'm just wondering > whether it's a bad idea to run them on the same server machine in a > production environment. (So instead of having 10 applications running on > Oracle on ServerComputerA...build a new postgresql instance on > ServerComputerA that lives along with Oracle and migrating 3 of the > applications to Postgresql. Have you got a spare machine you can do the testing on at first? That will allow you to throw big nasty queries at the server and tune it first, before putting postgresql on the production box. I'd recommend reading the tuning document from varlena: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html And experimenting with various settings on a test box first. My first PostgreSQL server way back when was running 6.5.2 or so on my P-II-300 workstation with 128 Megs of ram sitting under my desk, and it ran quite well, well enough we used it as our development / staging server for almost a year.