pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedabout multiprocessingmassdata
2+ messages / 2 participants
[nested] [flat]
* about multiprocessingmassdata
@ 2012-04-04 05:59 superman0920 <superman0920@gmail.com>
2012-04-04 14:11 ` Re: about multiprocessingmassdata Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 2+ messages in thread
From: superman0920 @ 2012-04-04 05:59 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: about multiprocessingmassdata
2012-04-04 05:59 about multiprocessingmassdata superman0920 <superman0920@gmail.com>
@ 2012-04-04 14:11 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2012-04-04 14:11 UTC (permalink / raw)
To: superman0920 <superman0920@gmail.com>; pgsql-admin
superman0920 <superman0920@gmail.com> wrote:
> 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 ?
Performance issues are best addressed on the pgsql-performance list,
not pgsql-admin. Before posting there, please read the following
page so that you can post enough information for people to make
useful suggestions:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
For perspective, in benchmarks on my own machines I have seen
complex data-modifying transactions running at 3000 transactions per
second, and we have production systems applying millions of complex
transactions per day against tables with hundreds of millions of
rows while serving web applications running tens of millions of
queries. So, my first thought is to wonder what the differences are
in your environment, and which of them might be causing problems.
To figure that out, I need to know more about your environment.
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-04-04 14:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-04-04 05:59 about multiprocessingmassdata superman0920 <superman0920@gmail.com>
2012-04-04 14:11 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox