Re: Updates are slow..
От | Ericson Smith |
---|---|
Тема | Re: Updates are slow.. |
Дата | |
Msg-id | 1023828124.31670.38.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Updates are slow.. ("Tom Burke" <lists@spamex.com>) |
Список | pgsql-general |
It would be also a good idea if you could send us the output of your system "ipcs" command so we can get an idea of the amount of shared memory you are using. - Ericson Smith eric@did-it.com http://www.did-it.com On Tue, 2002-06-11 at 15:22, Tom Lane wrote: > "Tom Burke" <lists@spamex.com> writes: > > For the purposes of our performance test, we created a PostgreSQL > > database with only a single table of about 1.2 million records. Updating > > an indexed column for 600K records on that table is unusually slow. It > > takes anywhere from forty minutes to over an hour. > > That seems way way off. I tried to replicate your situation on an RH > 7.2 box, using PG 7.1 (I don't have 7.2 installed there at the moment, > and current devel sources might be an unfair comparison). I got a time > more like forty seconds: > > test71=# create table emp (emp_id serial, dept_id int, emp_status int); > test71=# create index emp2 on emp(DEPT_ID, EMP_STATUS); > [ fill with random data ]
В списке pgsql-general по дате отправления: