Re: Slow inserts/deletes

From: "Frank Contrepois" <sokak(at)tin(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Slow inserts/deletes
Date: 2001-05-30 21:21:50
Message-ID: 9f3ogu$1p8b$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

If you use index on this table it's better to:
1) drop all index on the table
2) do the insert
3) (re)create the indexes

--
--

"L'idea di base estremamente semplice..."
opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Contrepois 2001-05-30 21:23:20 Re: START for SERIAL type?
Previous Message Tom Lane 2001-05-30 20:45:09 Re: Case Insensitive Queries