From: hubert depesz lubaczewski <depesz@depesz.com>
To: Frank Schoep <frank@ffnn.nl>
Cc: pgsql-performance@postgresql.org
Subject: Re: Bad planner decision - bitmap scan instead of index
Date: Fri, 17 Aug 2007 09:28:39 +0200
Message-ID: <20070817072839.GA6598@depesz.com> (raw)
In-Reply-To: <D9BD2209-87AD-4DA9-ACC9-D013A56FE7FA@ffnn.nl>
References: <D9BD2209-87AD-4DA9-ACC9-D013A56FE7FA@ffnn.nl>
On Thu, Aug 16, 2007 at 06:14:02PM +0200, Frank Schoep wrote:
> The (example) query:
> SELECT * FROM movies WHERE letter = 'T' ORDER BY name ASC LIMIT 100
> OFFSET 1900;
try to change the query to:
SELECT * FROM movies WHERE letter = 'T' ORDER BY letter ASC, name ASC LIMIT 100
OFFSET 1900;
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
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: depesz@depesz.com, frank@ffnn.nl
Subject: Re: Bad planner decision - bitmap scan instead of index
In-Reply-To: <20070817072839.GA6598@depesz.com>
* 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