{"id":3035,"date":"2011-05-21T06:59:00","date_gmt":"2011-05-21T14:59:00","guid":{"rendered":"http:\/\/www.chesnok.com\/daily\/2011\/05\/21\/twittering-on-2011-05-21\/"},"modified":"2011-05-21T06:59:00","modified_gmt":"2011-05-21T14:59:00","slug":"twittering-on-2011-05-21","status":"publish","type":"post","link":"https:\/\/www.chesnok.com\/daily\/2011\/05\/21\/twittering-on-2011-05-21\/","title":{"rendered":"twittering on 2011-05-21"},"content":{"rendered":"<ul class=\"aktt_tweet_digest\">\n<li>Lightning talks mostly uploaded (except the CBC talk that was slightly too large&#8230; working on it \ud83d\ude42 <a href=\"http:\/\/chesnok.com\/u\/2e\" rel=\"nofollow\">http:\/\/chesnok.com\/u\/2e<\/a> <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71576929978949632\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>Just heard from someone planning a 1 million table postgres instance. #<a href=\"http:\/\/search.twitter.com\/search?q=%23pgcon\" class=\"aktt_hashtag\">pgcon<\/a> <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71656101510266880\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>SSI (serializable snapshot isolation) has never been implemented in production in another database.  #<a href=\"http:\/\/search.twitter.com\/search?q=%23postgres\" class=\"aktt_hashtag\">postgres<\/a> #pgcon <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71674943896686592\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>&quot;And therefore transaction one is its own grandfather.. and that just doesn&#039;t work.&quot; #<a href=\"http:\/\/search.twitter.com\/search?q=%23pgcon\" class=\"aktt_hashtag\">pgcon<\/a> #ssi <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71678281388261376\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>&quot;The people who wrote the SQL standard got this wrong. They got it wrong more than once.&quot; #<a href=\"http:\/\/search.twitter.com\/search?q=%23ssi\" class=\"aktt_hashtag\">ssi<\/a> #pgcon <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71678440721481728\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>pro-tip: a read-only transaction can create a cycle of dependencies that make a transaction sequence not serializable. #<a href=\"http:\/\/search.twitter.com\/search?q=%23pgcon\" class=\"aktt_hashtag\">pgcon<\/a> <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71680675463438336\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>Basic idea: find a cycle in a graph, and break the transaction that caused it to preserve serializability. #<a href=\"http:\/\/search.twitter.com\/search?q=%23ssi\" class=\"aktt_hashtag\">ssi<\/a> #pgcon #<a href=\"http:\/\/search.twitter.com\/search?q=%23hopeigotthatright\" class=\"aktt_hashtag\">hopeigotthatright<\/a> <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71682668546371584\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>SSI rule is: don&#039;t let a transaction both have a rw-conflict *in* AND a rw-conflict *out* #<a href=\"http:\/\/search.twitter.com\/search?q=%23ssi\" class=\"aktt_hashtag\">ssi<\/a> #pgcon <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71683854028652544\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>SIREAD locks don&#039;t cause blocking (predicate locks are just flags). And they can persist beyond transaction commit. #<a href=\"http:\/\/search.twitter.com\/search?q=%23pgcon\" class=\"aktt_hashtag\">pgcon<\/a> #ssi <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71687204941996032\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>Agenda for tomorrow&#039;s Procedural Language summit <a href=\"http:\/\/wiki.postgresql.org\/wiki\/PgCon_2011_PL_Summit\" rel=\"nofollow\">http:\/\/wiki.postgresql.org\/wiki\/PgCon_2011_PL_Summit<\/a> #<a href=\"http:\/\/search.twitter.com\/search?q=%23pgcon\" class=\"aktt_hashtag\">pgcon<\/a> <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71689054718140417\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>Almost the end of #<a href=\"http:\/\/search.twitter.com\/search?q=%23pgcon\" class=\"aktt_hashtag\">pgcon<\/a>  \ud83d\ude41 <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71692832741654529\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>&quot;If it was hard to write it should be hard to use.&quot; -Jan Wieck #<a href=\"http:\/\/search.twitter.com\/search?q=%23slony\" class=\"aktt_hashtag\">slony<\/a> #pgcon <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71696816592265216\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<li>&quot;I don&#039;t want to have anything that says &quot;release it&quot; on the back.&quot; #<a href=\"http:\/\/search.twitter.com\/search?q=%23janwieck\" class=\"aktt_hashtag\">janwieck<\/a> #pgcon <a href=\"http:\/\/twitter.com\/selenamarie\/statuses\/71697220507934720\" class=\"aktt_tweet_time\">#<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Lightning talks mostly uploaded (except the CBC talk that was slightly too large&#8230; working on it \ud83d\ude42 http:\/\/chesnok.com\/u\/2e # Just heard from someone planning a 1 million table postgres instance. #pgcon # SSI (serializable snapshot isolation) has never been implemented &hellip; <a href=\"https:\/\/www.chesnok.com\/daily\/2011\/05\/21\/twittering-on-2011-05-21\/\">Continue reading &rarr;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[260],"class_list":["post-3035","post","type-post","status-publish","format-standard","hentry","category-twitter","tag-tweets"],"_links":{"self":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/3035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/comments?post=3035"}],"version-history":[{"count":0,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/3035\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/media?parent=3035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/categories?post=3035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/tags?post=3035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}