Re: How to make update rapidly?
| От | hewei |
|---|---|
| Тема | Re: How to make update rapidly? |
| Дата | |
| Msg-id | 4279588b0802192003h7245de7dw4314518a9e943b41@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to make update rapidly? ("Webb Sprague" <webb.sprague@gmail.com>) |
| Ответы |
Re: How to make update rapidly?
Re: How to make update rapidly? |
| Список | pgsql-general |
table:
CREATE TABLE price (
TIMESTAMP Timestamp NULL,
id numeric(5,0) NOT NULL,
price numeric(10,3) NULL,
primary key (id)
);
sql:
update price set price=* where id=*;
CREATE TABLE price (
TIMESTAMP Timestamp NULL,
id numeric(5,0) NOT NULL,
price numeric(10,3) NULL,
primary key (id)
);
sql:
update price set price=* where id=*;
On Feb 20, 2008 11:56 AM, Webb Sprague <webb.sprague@gmail.com> wrote:
Post the table, the query, and the explain output, and then we can help you.
On Feb 19, 2008 7:38 PM, hewei <heweiweihe@gmail.com> 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.
> what can i do? can you help me ?
>
В списке pgsql-general по дате отправления: