Postgres Pro
Downloads
Home   >   mailing lists

Re: Advise about how to delete entries - Mailing list pgsql-performance

From Arnau
Subject Re: Advise about how to delete entries
Date
Msg-id 431C0F48.5050809@andromeiberica.com
Whole thread Raw
In response to Re: Advise about how to delete entries  (PFC <lists@boutiquenumerique.com>)
Responses Re: Advise about how to delete entries  (Kevin <kev@drule.org>)
List pgsql-performance
Tree view 
Hi all,

 >
 >     COPY FROM a file with all the ID's to delete, into a temporary
table, and  do a joined delete to your main table (thus, only one query).


   I already did this, but I don't have idea about how to do this join,
could you give me a hint ;-) ?

Thank you very much
--
Arnau

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: poor VACUUM performance on large tables
Next
From: gdh@eyjar.is
Date:
Subject: Query slow after VACUUM ANALYZE