about multiprocessingmassdata

From: superman0920 <superman0920(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: about multiprocessingmassdata
Date: 2012-04-04 05:59:30
Message-ID: 201204041359218166912@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi
i have a table which has 8500000 rows record, i run 30 threads to update the record.
i find the database of processing data speed so slow, per thread updating 1000 rows need take 260s
How to configure the database to make processing speed faster ?
Please help ~~

superman0920

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bèrto ëd Sèra 2012-04-04 09:53:40 check_postgresql.pl for zabbix
Previous Message amador alvarez 2012-04-02 19:58:54 Re: custom conflict resolution information request