Search Postgresql Archives

Re: How to make update rapidly?

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

 



On Feb 19, 2008 9:38 PM, hewei <heweiweihe@xxxxxxxxx> wrote:
> 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.

Assuming that you're updating a non-indexed field, you should really
look at migrating to 8.3 if you haven't already.  It's performance on
such issues is reportedly much faster than 8.2.

As for processing them in order versus randomly, that's a common
problem.  right sizing shared_buffers so that all of the table can fit
in ram might help too.  As would a caching RAID controller.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux