Re: low performance

Поиск
Список
Период
Сортировка
От grant
Тема Re: low performance
Дата
Msg-id Pine.LNX.4.33.0108201021340.26513-100000@c70051-a.aurora1.co.home.com
обсуждение исходный текст
Ответ на low performance  (Andreas Wernitznig <andreas@insilico.com>)
Ответы Re: low performance
Список pgsql-bugs
Is this running as one transaction, or is it not a transaction?  Have you
tried committing every 10,000 or so if it is in one transaction?  It could
be a logging problem with the transaction being too big.

Does the file system as a whole get slow, or just Postgres?  Is it one
connection, or does it disconnect and reconnect a lot?

Is it the main postmaster sucking up all the CPU, or the one spawned by
the PERL, or the one spawned by psql?

How much do the file system cache and io buffers grow?
______________________________________________________________________________

                          Your mouse has moved.
       You must restart Windows for your changes to take effect.

#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);

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