RE: Berkeley DB... - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Berkeley DB...
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018C0C@SECTORBASE1
Whole thread Raw
In response to Berkeley DB...  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Responses Re: Berkeley DB...
RE: Berkeley DB...
List 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


pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: but i _really can't_ insert a duplicate key!
Next
From: Tatsuo Ishii
Date:
Subject: Regression test failure on 7.0-STABLE