Re: TRUNCATE HANGS

Поиск
Список
Период
Сортировка
От tmoore
Тема Re: TRUNCATE HANGS
Дата
Msg-id 1291490814911-3292403.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: TRUNCATE HANGS  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: TRUNCATE HANGS
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: TRUNCATE HANGS