Home > mailing lists

Re: Slow inserts/deletes - Mailing list pgsql-sql

From	Frank Contrepois
Subject	Re: Slow inserts/deletes
Date	June 5, 2001 19:58:32
Msg-id	9f3ogu$1p8b$1@news.tht.net Whole thread Raw
In response to	Slow inserts/deletes ("Diehl, Jeffrey" <jdiehl@sandia.gov>)
List	pgsql-sql

Tree view

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)

pgsql-sql by date:

From: "stone"
Date: 05 June 2001, 19:58:02
Subject: How to use the template table in postgresql

From: reinoud@xs4all.nl (Reinoud van Leeuwen)
Date: 05 June 2001, 20:03:57
Subject: Re: Date manipulation

Re: Slow inserts/deletes - Mailing list pgsql-sql

Previous

Next