How to make update rapidly?

From: hewei <heweiweihe(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to make update rapidly?
Date: 2008-02-20 03:38:50
Message-ID: 4279588b0802191938n41be897dnf9882f6025ae46e3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,Every body;
I have a table contains 100,000 rows, and has a primary key(int).
Now ,I need to execute sql command like "update .......... where id=*"(id
is primary key).
I expect execute 1200-1600 sqlcommands per second(1200-1600/s).
In test,when the id increase by degrees in sqlcommands, then I can reach
the speed(1600/s);
But in fact , the id in sqlcommands is out of rule, then the speed is
very slow, just 100/s.
what can i do? can you help me ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Webb Sprague 2008-02-20 03:56:03 Re: How to make update rapidly?
Previous Message Postgres User 2008-02-20 03:32:42 Regex query not using index