Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow duplicate deletes - Mailing list pgsql-novice

From DrYSG
Subject Re: Slow duplicate deletes
Date
Msg-id 1331132978011-5544386.post@n5.nabble.com
Whole thread Raw
In response to Re: Slow duplicate deletes  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-novice
Tree view 
The following query took only 16 hours 2 minutes

CREATE TABLE portal.new_metatdata AS
select distinct on (data_object.unique_id) * FROM portal.metadata;

Thank you.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Slow-duplicate-deletes-tp5537818p5544386.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

pgsql-novice by date:

Previous
From: Majid Azimi
Date:
Subject: Is Tablespace something like Logical Volume?
Next
From: Carlos Mennens
Date:
Subject: Numeric Data Type Rounding Up