Re: [BUGS] BUG #1331: after update: vacuum blocks parallel to select

2004-11-29 Thread Enke, Michael
But the description says: vacuum can run parallel to selects. This is than not true. Regards, Michael Tom Lane schrieb: "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: Description:after update: vacuum blocks parallel to select This isn't a bug, it's simply vacuum waiting until it can ac

Re: [BUGS] BUG #1331: after update: vacuum blocks parallel to select

2004-11-29 Thread Tom Lane
"Enke, Michael" <[EMAIL PROTECTED]> writes: > But the description says: vacuum can run parallel to selects. > This is than not true. Sure it can; but that doesn't mean there is no interlocking at all. The issue you have is not so much that the select is running as that it is *not* running, ie, it

Re: [BUGS] BUG #1331: after update: vacuum blocks parallel to select

2004-11-29 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Description:after update: vacuum blocks parallel to select This isn't a bug, it's simply vacuum waiting until it can acquire a page-level lock. regards, tom lane ---(end of broadcast)

[BUGS] BUG #1331: after update: vacuum blocks parallel to select

2004-11-29 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1331 Logged by: Michael Enke Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.5 Operating system: Linux SuSE 9.1 Kernel 2.6/RedHat 9 Kernel 2.4 Description:after update: vacuum blocks parallel to sel