view release on metacpan or  search on metacpan

t/data/theory.atom  view on Meta::CPAN

63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<dc:subject>glue+finance</dc:subject>
<dc:subject>ActiveRecord</dc:subject>
<issued>2010-11-24T22:30:00Z</issued>
<modified>2010-11-24T22:30:00Z</modified>
<author>
  <name>David E. Wheeler</name>
</author>
<content type="text/html" xml:base="http://www.justatheory.com" xml:lang="en-us" xml:space="preserve" mode="escaped">
&lt;p&gt;&lt;a href="http://pgexperts.com/"&gt;PGX&lt;/a&gt; had &lt;a href="http://gluefinance.com/"&gt;a client&lt;/a&gt; come to us recently with a rather nasty deadlock issue. It took far longer than we would have liked to figure out the issue, a...
 
&lt;p&gt;Some might consider it a bug in PostgreSQL, but the truth is that PostgreSQL can obtain stronger than necessary locks. Such locks cause some operations to block unnecessarily and some other operations to deadlock, especially when foreign key...
 
&lt;p&gt;Fortunately, Simon Riggs &lt;a href="http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg158205.html"&gt;proposed a solution&lt;/a&gt;. And it&amp;rsquo;s a good one. So good that &lt;a href="http://pgexperts.com/"&gt;PGX&lt;/a&gt; i...
 
&lt;p&gt;If you use foreign key constraints (and you should!) and you have a high transaction load on your database (or expect to soon!), this matters to you. In fact, if you use ActiveRecord with Rails, there might even be a special place in your he...
 
&lt;p&gt;Yes, that&amp;rsquo;s right, as with &lt;a href="http://pgxn.org/"&gt;PGXN&lt;/a&gt;, this is community project for which we&amp;rsquo;re raising funds from the community to get it done. I think that more and more work could be done this way...
 
&lt;p&gt;Help us help the community to make PostgreSQL better than ever!&lt;/p&gt;
&lt;img src="http://feeds.feedburner.com/~r/justatheory/atomfull/~4/QqjV_Ciqgvg" height="1" width="1"/&gt;</content>
<feedburner:origLink>http://www.justatheory.com/computers/databases/postgresql/fk-locks-project.html</feedburner:origLink></entry>

t/data/theory.rss  view on Meta::CPAN

82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
    <title>Fixing Foreign Key Deadlocks in PostgreSQL</title>
    <link>http://feedproxy.google.com/~r/justatheory/rssfull/~3/1gH2UXNHffw/fk-locks-project.html</link>
    <description />
    <dc:subject>/computers/databases/postgresql</dc:subject>
    <dc:creator>David E. Wheeler</dc:creator>
    <dc:date>2010-11-24T22:30-08:00</dc:date>
     
    <cc:license rdf:resource="http://creativecommons.org/licenses/by-nc/2.0" />
    <content:encoded><![CDATA[<p><a href="http://pgexperts.com/">PGX</a> had <a href="http://gluefinance.com/">a client</a> come to us recently with a rather nasty deadlock issue. It took far longer than we would have liked to figure out the issue, a...
 
<p>Some might consider it a bug in PostgreSQL, but the truth is that PostgreSQL can obtain stronger than necessary locks. Such locks cause some operations to block unnecessarily and some other operations to deadlock, especially when foreign keys are ...
 
<p>Fortunately, Simon Riggs <a href="http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg158205.html">proposed a solution</a>. And it&rsquo;s a good one. So good that <a href="http://pgexperts.com/">PGX</a> is partnering with <a href="http://...
 
<p>If you use foreign key constraints (and you should!) and you have a high transaction load on your database (or expect to soon!), this matters to you. In fact, if you use ActiveRecord with Rails, there might even be a special place in your heart fo...
 
<p>Yes, that&rsquo;s right, as with <a href="http://pgxn.org/">PGXN</a>, this is community project for which we&rsquo;re raising funds from the community to get it done. I think that more and more work could be done this way, as various interested pa...
 
<p>Help us help the community to make PostgreSQL better than ever!</p>
<img src="http://feeds.feedburner.com/~r/justatheory/rssfull/~4/1gH2UXNHffw" height="1" width="1"/>]]></content:encoded>
  <feedburner:origLink>http://justatheory.com/computers/databases/postgresql/fk-locks-project.html</feedburner:origLink></item>