[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

about multiprocessingmassdata

Subject: about multiprocessingmassdata
From: superman0920 <superman0920@xxxxxxxxx>
Date: Wed, 4 Apr 2012 13:59:30 +0800
Reply-to: superman0920 <superman0920@xxxxxxxxx>
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

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

Follow-Ups:
- Re: about multiprocessingmassdata
  - From: Kevin Grittner

Prev by Date: Segmentation fault ( after Shared Lock acquired, same table 4 times )
Next by Date: check_postgresql.pl for zabbix
Previous by thread: Segmentation fault ( after Shared Lock acquired, same table 4 times )
Next by thread: Re: about multiprocessingmassdata
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]