Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

From: Steve Singer <ssinger_pg(at)sympatico(dot)ca>
To: David Fetter <david(at)fetter(dot)org>
Cc: Peter Childs <peterachilds(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [GENERAL] PostgreSQL versus MySQL for GPS Data
Date: 2009-04-22 03:19:37
Message-ID: BLU0-SMTP65BB1C241EED10E19D5A9BAC740@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-general
On Tue, 21 Apr 2009, David Fetter wrote:

> On Tue, Apr 21, 2009 at 08:15:00PM +0100, Peter Childs wrote:
>> Hmm Interestingly OSM have just switched from MySQL to PostgreSQL.
>
> Can we get somebody from OSM to talk about this on the record?

I've forwarded this request the to the OSM talk list.  Hopefully someone who 
can talk 'on the record' will step forward.

The master OSM database used for editing used to by MySQL but most of the 
map rendering was done from Postgis hosted data.  Over the weekend they 
switched ,as part of an API upgrade,  the main editing database 
to Postgresql (but still not using complex geometry types).

I think the reasoning had to do with them wanting transactions and the 
switch to InnoDB brought has some downsides, but I don't know which of the 
innodb downsides motivated the switch.

I think the reference to MonetDB was part of an April fools joke.

Steve

>
> Cheers,
> David.
> -- 
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
> Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>
> -- 
> Sent via pgsql-advocacy mailing list (pgsql-advocacy(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-advocacy
>


In response to

Responses

pgsql-advocacy by date

Next:From: Scott MarloweDate: 2009-04-22 03:27:43
Subject: Re: [pgsql-advocacy] PostgreSQL versus MySQL for GPS Data
Previous:From: David FetterDate: 2009-04-21 20:09:08
Subject: Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

pgsql-general by date

Next:From: Scott MarloweDate: 2009-04-22 03:27:43
Subject: Re: [pgsql-advocacy] PostgreSQL versus MySQL for GPS Data
Previous:From: Bill ToddDate: 2009-04-22 01:58:00
Subject: What must be installed on client for ODBC connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group