Re: Help speeding up delete

From: Arjen van der Meijden <acmmailing(at)tweakers(dot)net>
To: Steve Wampler <swampler(at)noao(dot)edu>
Cc: Postgres-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help speeding up delete
Date: 2005-11-16 20:22:17
Message-ID: 437B94F9.20306@tweakers.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 15-11-2005 15:18, Steve Wampler wrote:
> Magnus Hagander wrote:
> (This is after putting an index on the (id,name,value) tuple.) That outer seq scan
> is still annoying, but maybe this will be fast enough.
>
> I've passed this on, along with the (strong) recommendation that they
> upgrade PG.

Have you tried with an index on (name,value) and of course one on id ?

Best regards,

Arjen

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steve Wampler 2005-11-16 20:29:44 Re: Help speeding up delete
Previous Message Scott Marlowe 2005-11-16 20:08:03 Re: Hardware/OS recommendations for large databases (