Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group