Date: Wed, 25 May 2005 13:44:56 -0400
From: Alvaro Herrera <alvherre@surnet.cl>
To: lucas@presserv.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Duplicated records
Message-ID: <20050525174456.GC8590@surnet.cl>
References: <20050524175931.4dp41vy7v10c4wc4@www.presserv.org>
	<20050525050346.GA29126@webserv.wug-glas.de>
	<20050525135807.x9p08co04v8gg0cw@www.presserv.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050525135807.x9p08co04v8gg0cw@www.presserv.org>
User-Agent: Mutt/1.5.9i

On Wed, May 25, 2005 at 01:58:07PM -0300, lucas@presserv.org wrote:

> The records is entire duplicated (with all fields having the same data),
> thinking the "numos" fields as primary key I have executed the query:
> 
> # DELETE from lanctos where not oid=(select oid from lanctos as l2 where
> l2.numos=lanctos.numos limit 1);

That's because you don't have an index on the Oid column.  You may want
to try using the ctid column instead; it's the physical row position in
the table so it doesn't need to scan the whole table each time.

HTH,

-- 
Alvaro Herrera (<alvherre[a]surnet.cl>)
"The only difference is that Saddam would kill you on private, where the
Americans will kill you in public" (Mohammad Saleh, 39, a building contractor)