Re: TRUNCATE HANGS - Mailing list pgsql-bugs

From tmoore
Subject Re: TRUNCATE HANGS
Date
Msg-id 1291490814911-3292403.post@n5.nabble.com
Whole thread Raw
In response to Re: TRUNCATE HANGS  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-bugs
Can I ask you to elaborate on one of your comments before I move to the
general thread ?


You mention committing the 'idle thread'. The test is not doing
any transaction based work, the write functions just do sql insert, no begin
commit blocks at the application level.

Any tips on interpreting pg_locks ?

Last thing, the test was modified such that only insert and truncate
activity was done, no selects.
No blocking occurred.

Tom



--
View this message in context: http://postgresql.1045698.n5.nabble.com/TRUNCATE-HANGS-tp3292333p3292403.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: TRUNCATE HANGS
Next
From: "Kevin Grittner"
Date:
Subject: Re: TRUNCATE HANGS