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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 ~~



pgsql-admin by date

Next:From: Bèrto ëd SèraDate: 2012-04-04 09:53:40
Subject: 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-2017 The PostgreSQL Global Development Group