Re: reindex and copy - deadlock?

От: Tom Lane
Тема: Re: reindex and copy - deadlock?
Дата: ,
Msg-id: 18172.1086985673@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: reindex and copy - deadlock?  (Litao Wu)
Ответы: Re: reindex and copy - deadlock?  (Litao Wu)
Re: reindex and copy - deadlock?  (Litao Wu)
Список: pgsql-performance

Скрыть дерево обсуждения

Join slow on "large" tables  (Josué Maldonado, )
 Re: Join slow on "large" tables  (Josh Berkus, )
  Re: Join slow on "large" tables  (Josué Maldonado, )
   Re: Join slow on "large" tables  (Josh Berkus, )
    Re: Join slow on "large" tables  (Josué Maldonado, )
   Re: Join slow on "large" tables  (Tom Lane, )
 Re: Join slow on "large" tables  ("Scott Marlowe", )
  Re: Join slow on "large" tables  (Josué Maldonado, )
   reindex and copy - deadlock?  (Litao Wu, )
    Re: reindex and copy - deadlock?  (Tom Lane, )
     Re: reindex and copy - deadlock?  (Litao Wu, )
      Re: reindex and copy - deadlock?  (Tom Lane, )
       Re: reindex and copy - deadlock?  (Litao Wu, )
        Re: reindex and copy - deadlock?  (Tom Lane, )
         Re: reindex and copy - deadlock?  (Litao Wu, )
          Re: reindex and copy - deadlock?  (Tom Lane, )
           Re: reindex and copy - deadlock?  (Litao Wu, )
            Re: reindex and copy - deadlock?  (Tom Lane, )
           Re: reindex and copy - deadlock?  (Litao Wu, )
            Re: reindex and copy - deadlock?  (Tom Lane, )
             Re: reindex and copy - deadlock?  (Litao Wu, )
              Re: reindex and copy - deadlock?  (Tom Lane, )
               Re: reindex and copy - deadlock?  (Litao Wu, )
                Re: reindex and copy - deadlock?  (Tom Lane, )
                 network address query  (Litao Wu, )
   Re: Join slow on "large" tables  ("Scott Marlowe", )

Litao Wu <> writes:
> One difference between these two databases
> is the one having REINDEX problem is using
> NTFS file system.

Oh?  That's interesting.

> Is it possible the root of problem?

I would not expect it to show this particular symptom --- if the
backtrace is accurate.  But there are nearby places that might have
FS-dependent behavior.  Can you do anything about my request for
a stack trace from a debug-enabled build?

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: in-transaction insert performance in 7.5devel
От: Vitaly Belman
Дата:
Сообщение: Additional select fields in a GROUP BY