Re: How to determine cause of performance problem?

Поиск
Список
Период
Сортировка
От Joost Kraaijeveld
Тема Re: How to determine cause of performance problem?
Дата
Msg-id 1127486824.3524.58.camel@Panoramix
обсуждение исходный текст
Ответ на Re: How to determine cause of performance problem?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: How to determine cause of performance problem?
Список pgsql-performance
On Fri, 2005-09-23 at 10:33 -0400, Tom Lane wrote:
> Is the client code running on the same machine as the database server?
> If not, what's the network delay and latency between them?
Yes, it is running on the same machine.


> The major problem you're going to have here is at least one network
> round trip per row inserted --- possibly more, if the jdbc driver is
> doing "helpful" stuff behind your back like starting/committing
> transactions.
OK, I will look into that.

But do you maybe know a pointer to info, or tools that can measure, what
my machine is doing during all the time it is doing nothing? Something
like the performance monitor in Windows but than for Linux?

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to determine cause of performance problem?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to determine cause of performance problem?