Re: Questions about Postgres and Oracle

From: Igor Neyman <igor.neyman_at_gmail.com>
Date: Fri, 21 Dec 2012 10:20:34 -0500
Message-ID: <CAJoeKmvbPBHT+uCAHpuLj9_CdL=YXfKznujG1=_JN0r7ujWu0Q_at_mail.gmail.com>

Postgres getting better in that regard, still not as convenient/advanced as Oracle, but it definitely moves in the right direction. AUTO_EXPLAIN extension is one of the tools that could be used for sql tracing/profiling.
As for Stonebrake, he hasn't been associated with Postgres for many years. Current group of developers (hackers) is very solid.

Regards,
Igor Neyman

On Fri, Dec 21, 2012 at 5:38 AM, Frits Hoogland <frits.hoogland_at_gmail.com>wrote:

> Content-Transfer-Encoding: quoted-printable
> Content-Type: text/plain;
> charset=iso-8859-1
> I've got a few customers using Postgresql, as an alternative for Oracle =
> because of cost.
>
> Most notable is pg/sql, which is alike pl/sql.=20
>
> I wouldn't use it if needs to drive anything to the edge. It lacks the =
> ability to profile the time spend by the database on the database level =
> (at least: last time I looked, with pg 8.x)
> For "normal usage" (whatever that means), it's a viable alternative.
>
> Frits Hoogland
>
> http://fritshoogland.wordpress.com
> frits.hoogland_at_gmail.com
> +31 6 53569942
>
> On Dec 21, 2012, at 10:31 AM, Nuno Souto <dbvision_at_iinet.net.au> wrote:
>
> > kyle Hailey wrote,on my timestamp of 21/12/2012 4:05 AM:
> >=20
> >> Postgres looks pretty cool to me. Nothing against Oracle.
> >> And a number of or clients are going Oracle -> Postgres so I'm keenly
> >> interested in the issues and feasibility.
> >=20
> > We've been using Postgres for all our web-related dbs for years now.
> > Not only is it heaps cheaper than Oracle, it's reached a level =
> nowadays where it=20
> > is quite usable. Regardless of the perorations of Stonebraker - who =
> has been=20
> > remarkable silent since his last "take over the Oracle world" crusade =
> fizzled=20
> > before it even started... - Postgres is a viable alternative. And it =
> actually=20
> > can interface with Oracle quite well through the HS magic.
> > Not about to move our DW to it but a lot of other smaller stuff is =
> being=20
> > seriously considered.
> >=20
> > --=20
> > Cheers
> > Nuno Souto
> > in overcast Sydney, Australia
> > dbvision_at_iinet.net.au
> > --
> > http://www.freelists.org/webpage/oracle-l
> >=20
> >=20
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 21 2012 - 16:20:34 CET