From: Leigh Dyer <lsd@linuxgamers.net>
To: Postgres-performance <pgsql-performance@postgresql.org>
Subject: Re: Help speeding up delete
Date: Tue, 15 Nov 2005 12:18:48 +1100
Message-ID: <43793778.7040006@linuxgamers.net> (raw)
In-Reply-To: <43792523.5090003@noao.edu>
References: <43790A99.9050603@noao.edu>
<4162.1132011763@sss.pgh.pa.us>
<43792523.5090003@noao.edu>
Steve Wampler wrote:
>
> Is the performance behavior that we're experiencing a known
> problem with 7.2 that has been addressed in 7.4? Or will the
> upgrade fix other problems while leaving this one?
I'm pretty sure that in versions earlier than 7.4, IN clauses that use a
subquery will always use a seqscan, regardless of what indexes are
available. If you try an IN using explicit values though, it should use
the index.
Thanks
Leigh
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: lsd@linuxgamers.net
Subject: Re: Help speeding up delete
In-Reply-To: <43793778.7040006@linuxgamers.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