| From: | Steve Wampler <swampler(at)noao(dot)edu> |
|---|---|
| To: | Arjen van der Meijden <acmmailing(at)tweakers(dot)net> |
| Cc: | Postgres-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Help speeding up delete |
| Date: | 2005-11-16 20:29:44 |
| Message-ID: | 437B96B8.2090302@noao.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2005-11-16 20:57:20 | Re: Hardware/OS recommendations for large databases |
| Previous Message | Arjen van der Meijden | 2005-11-16 20:22:17 | Re: Help speeding up delete |