От: Tom Lane
Тема: Re: Performance Query
Дата: ,
Msg-id: 23598.1172887923@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Performance Query  (Josh Berkus)
Список: pgsql-performance

Josh Berkus <> writes:
>> Please help in understanding how I can find out what the system is
>> waiting for or why is it taking the query so long.

> First guess would be I/O bound.  The planner, at least, thinks you're
> inserting 2 million records.  What kind of disk support do you have?

I don't see any need to guess.  iostat or vmstat or local equivalent
will show you quick enough if you are maxing out the disk or the CPU.

It seems at least somewhat possible that the thing is blocked on a lock,
in which case the pg_locks view would tell you about it.

            regards, tom lane

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

От: Dennis Bjorklund
Сообщение: Re: Upgraded to 8.2.3 --- still having performance issues
От: Arjen van der Meijden
Сообщение: Re: Opinions on Raid