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 по дате отправления: