Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: delete duplicates takes too long
- From: Dennis Brakhane <brakhane(at)googlemail(dot)com>
- To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- Cc: Miguel Miranda <miguel(dot)mirandag(at)gmail(dot)com>, mmiranda(at)amnetcorp(dot)com, pgsql-general(at)postgresql(dot)org
- Subject: Re: delete duplicates takes too long
- Date: Thu, 30 Apr 2009 19:23:53 +0200
- Message-id: <226a19190904301023q6d04da22o624e94fc9680e703@mail.gmail.com> <text/plain>
On Sat, Apr 25, 2009 at 2:51 AM, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote: > In that case you can create a partial unique index: > > create index foo on cdr_ama_stat (abonado_a, abonado_b, fecha_llamada, > duracion) where processed = 2; Of course, the unique is missing in this one: CREATE UNIQUE INDEX foo ON cdr_ama_stat (abonado_a, abonado_b, fecha_llamada, duracion) WHERE processed = 2;
- References:
- delete duplicates takes too long
- From: Miguel Miranda
- Re: delete duplicates takes too long
- From: Scott Marlowe
- Re: delete duplicates takes too long
- From: Miguel Miranda
- Re: delete duplicates takes too long
- From: Alvaro Herrera
- delete duplicates takes too long
- Prev by Date: Re: ERROR: syntax error at or near "IF"... why?
- Next by Date: Re: possible consistency problem
- Previous by thread: Re: delete duplicates takes too long
- Next by thread: delete cascade not working
- Indexes: