From: Steve Wampler <swampler@noao.edu>
To: Arjen van der Meijden <acmmailing@tweakers.net>
Cc: Postgres-performance <pgsql-performance@postgresql.org>
Subject: Re: Help speeding up delete
Date: Wed, 16 Nov 2005 13:29:44 -0700
Message-ID: <437B96B8.2090302@noao.edu> (raw)
In-Reply-To: <437B94F9.20306@tweakers.net>
References: <6BCB9D8A16AC4241919521715F4D8BCE6C7BC4@algol.sollentuna.se>
<4379EE24.8000504@noao.edu>
<437B94F9.20306@tweakers.net>
Arjen van der Meijden wrote:
> 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 ?
Yes, although not with a unique index on (name,value) [possible, but not
so on the just-id index]. Anyway, it turns out the latest incarnation
is 'fast enough' for the user's need, so she's not doing any more with
it until after an upgrade.
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: swampler@noao.edu, acmmailing@tweakers.net
Subject: Re: Help speeding up delete
In-Reply-To: <437B96B8.2090302@noao.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox