Postgres Pro
Downloads
Home   >   mailing lists

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...  (Tom Lane <tgl@sss.pgh.pa.us>)
RE: Berkeley DB...  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
Tree view 
> > 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