Paul Ramsey wrote: > Did the FAA ever publish slides of those talks? Sure wish I could see them... :) No, sorry, I don't think I ever saw the slides published. --------------------------------------------------------------------------- > > P. > > On 2010-08-11, at 6:58 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote: > > > Greg Smith wrote: > >> Greg Williamson wrote: > >>> Our tests -- very much oriented at postGIS found Oracle to be between 5 > >>> and 15% _faster_ depending on the specifics of the task. We decided to go > >>> with postgres given the price difference (several hundred thousand dollars for > >>> Oracle in the configuration we needed vs. zip for postgres -- we already had > >>> trained postgres DBAs). > >>> > >> > >> Can always throw the licensing savings toward larger hardware too; $100K > >> buys a pretty big server nowadays. At the FAA's talk about their > >> internal deployment of PostgreSQL: > >> https://www.postgresqlconference.org/2010/east/talks/faa_airports_gis_and_postgresql > >> > >> They were reporting that some of their difficult queries were > >> dramatically faster on PostgreSQL; I vaguely recall one of them was 100X > >> the speed it ran under Oracle Spatial. It was crazy. As always this > >> sort of thing is very workload dependent. There are certainly queries > >> (such as some of the ones from the TPC-H that big DB vendors optimize > >> for) that can be 100X faster on Oracle too. > > > > The FAA reported something like that at PG East about Oracle vs. > > Postgres performance with GIS data. > > > > -- > > Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us > > EnterpriseDB http://enterprisedb.com > > > > + It's impossible for everything to be true. + > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
