From: Arjen van der Meijden <acmmailing@tweakers.net>
To: Steve Wampler <swampler@noao.edu>
Cc: Postgres-performance <pgsql-performance@postgresql.org>
Subject: Re: Help speeding up delete
Date: Wed, 16 Nov 2005 21:22:17 +0100
Message-ID: <437B94F9.20306@tweakers.net> (raw)
In-Reply-To: <4379EE24.8000504@noao.edu>
References: <6BCB9D8A16AC4241919521715F4D8BCE6C7BC4@algol.sollentuna.se>
<4379EE24.8000504@noao.edu>
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
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: acmmailing@tweakers.net, swampler@noao.edu
Subject: Re: Help speeding up delete
In-Reply-To: <437B94F9.20306@tweakers.net>
* 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