view release on metacpan or  search on metacpan

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

<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

    <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>