User: Password:
|
|
Subscribe / Log in / New account

PGCon 2014: Clustering and VODKA

PGCon 2014: Clustering and VODKA

Posted Jun 5, 2014 1:32 UTC (Thu) by kjp (subscriber, #39639)
Parent article: PGCon 2014: Clustering and VODKA

The slides on UPSERT were great ("looking into the future", pushing the limits of mvcc, etc.). It's wild that you can do predicate locking / serializable transactions but no upsert yet [I'm guessing because people are more willing/ prepared to retry serializable failures].

Any contributions from Amazon? Getting picked up by RDS (I see it's still in beta) was a big win for you guys.


(Log in to post comments)

PGCon 2014: Clustering and VODKA

Posted Jun 5, 2014 1:35 UTC (Thu) by kjp (subscriber, #39639) [Link]

I can answer my own question: there was a talk about rds. http://www.pgcon.org/2014/schedule/events/640.en.html

PGCon 2014: Clustering and VODKA

Posted Jun 5, 2014 2:51 UTC (Thu) by petereisentraut (subscriber, #59453) [Link]

That presentation was not by Amazon, it was about Amazon.

PGCon 2014: Clustering and VODKA

Posted Jun 5, 2014 2:50 UTC (Thu) by petereisentraut (subscriber, #59453) [Link]

Getting PostgreSQL into RDS was great, but Amazon hasn't been contributing to PostgreSQL so far. They have sponsored other PostgreSQL conferences.

PGCon 2014: Clustering and VODKA

Posted Jun 5, 2014 18:28 UTC (Thu) by jberkus (subscriber, #55561) [Link]

kjp,

Well, that's the PostgreSQL project motto: "making hard things possible, saving the easy things for later." ;-)

PGCon 2014: Clustering and VODKA

Posted Jun 5, 2014 18:31 UTC (Thu) by jberkus (subscriber, #55561) [Link]

KJP,

More seriously, as you can see from the slides, making UPSERT work correctly turns out to be quite hard in a high-concurrency environment. MySQL was willing to impose serialization on their users, partly because they already had to support their original replication system. We can't, because our users wouldn't tolerate it.


Copyright © 2017, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds