Postgres Pro
Downloads
Home   >   mailing lists

about multiprocessingmassdata - Mailing list pgsql-admin

From superman0920
Subject about multiprocessingmassdata
Date
Msg-id 201204041359218166912@gmail.com
Whole thread Raw
Responses Re: about multiprocessingmassdata
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Jan Mussler
Date:
Subject: Segmentation fault ( after Shared Lock acquired, same table 4 times )
Next
From: Bèrto ëd Sèra
Date:
Subject: check_postgresql.pl for zabbix