Re: Updates are slow..

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(at)did-it(dot)com
http://www.did-it.com

On Tue, 2002-06-11 at 15:22, Tom Lane wrote:
> "Tom Burke" <lists(at)spamex(dot)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 ]