RE: Berkeley DB...

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Mike Mascari <mascarm(at)mascari(dot)com>, Matthias Urlichs <smurf(at)noris(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject: RE: Berkeley DB...
Date: 2000-05-28 04:44:52
Message-ID: 8F4C99C66D04D4118F580090272A7A23018C0C@SECTORBASE1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Well, I've dropped index but INSERTs still take 70 sec and
> > COPY just 1sec -:(((
> >
>
> Did you run vacuum after dropping indexes ?
> Because DROP INDEX doesn't update relhasindex of pg_class,
> planner/executer may still look up pg_index.

Actually, I dropped and re-created table without indices...

Vadim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2000-05-28 04:56:22 Regression test failure on 7.0-STABLE
Previous Message Alfred Perlstein 2000-05-27 22:58:30 but i _really can't_ insert a duplicate key!