PostgreSQL 9.5: UPSERT, Row Level Security, and Big Data
Unless I&#x27;m mistaken MySQL has had this for almost a decade with &quot;ON DUPLICATE KEY UPDATE&quot;. I&#x27;m seeing a lot more about PSQL here and in the news. I&#x27;ve always found it to be unfriendly and slow. Why the new attention? Is there really something about PSQL that makes it better than MySQL these days? It used to be transactions, but InnoDB made that moot years ago.<p>We do over 20,000 queries per second on one of our production mysql DB&#x27;s and I&#x27;m not sure I&#x27;d trust anything else with that: <a href="http:&#x2F;&#x2F;i.imgur.com&#x2F;sLZzXhS.png" rel="nofollow">http:&#x2F;&#x2F;i.imgur.com&#x2F;sLZzXhS.png</a><p>Just curious if I&#x27;m missing out on some new awesomeness that PostgreSQL has or if it&#x27;s just marketing.