| From: | Tiago Daniel Jacobs <tiago(at)mdtestudio(dot)com(dot)br> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Subject: | Re: BUG #3479: contraint exclusion and locks |
| Date: | 2007-07-23 14:46:31 |
| Message-ID: | 46A4BF47.1080004@mdtestudio.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<small><font face="Arial">Tom and Gregory. U're right! The problem is
that we're using constraints for partitioned tables and by definition,
a partition never, absolutely never, can affect the entire system.<br>
<br>
But I think that we have nothing to do about this. There are plans to
another kind of partitioning? If yes, I would like to contribute. If
not, i`m okay. <br>
<br>
Just tried to help.<br>
<br>
Okay, sorry about take your time for it.<br>
<br>
Tiago<br>
<br>
<br>
Tom Lane escreveu:
<blockquote type="cite">
<pre wrap=""><small><font>"Tiago Jacobs" <a class="moz-txt-link-rfc2396E" href="mailto:tiago(at)mdtestudio(dot)com(dot)br"><tiago(at)mdtestudio(dot)com(dot)br></a> writes:
</font></small></pre>
<blockquote type="cite">
<pre wrap=""><small><font>oh-ow... It waits while the table (That is not used) is locked.
</font></small></pre>
</blockquote>
<pre wrap=""><!---->
<small><font>This is not a bug. It has to inspect the table to find out that
there is a constraint.
regards, tom lane
</font></small></pre>
</blockquote>
<br>
<br>
<br>
</font></small>Gregory Stark escreveu:
<blockquote cite="mid87y7h7kxj4(dot)fsf(at)oxford(dot)xeocode(dot)com" type="cite">
<pre wrap="">"Tiago Jacobs" <a class="moz-txt-link-rfc2396E" href="mailto:tiago(at)mdtestudio(dot)com(dot)br"><tiago(at)mdtestudio(dot)com(dot)br></a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">oh-ow... It waits while the table (That is not used) is locked.
Even that the final plan dont use tab_2007_07, it wait for unlock of table
for make the plan.
</pre>
</blockquote>
<pre wrap=""><!---->
Well one of the reasons exclusive locks are taken are to make changes to
constraints.
</pre>
<blockquote type="cite">
<pre wrap="">So, if I`m running a VACUUM on specific table, all the querys on the
"master" table don't work.
</pre>
</blockquote>
<pre wrap=""><!---->
VACUUM doesn't take an exclusive lock. VACUUM is designed to be run regularly
without interfering with full use of the table.
You're not running VACUUM FULL are you? That's much more intrusive and
shouldn't be needed in regular operation.
</pre>
</blockquote>
<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 2.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-07-23 15:34:54 | Re: BUG #3479: contraint exclusion and locks |
| Previous Message | Tom Lane | 2007-07-23 14:37:13 | Re: BUG #3479: contraint exclusion and locks |