From: Ragnar Hafstaư <gnari@simnet.is>
To: Alex Turner <armtuk@gmail.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Planner issue
Date: Tue, 22 Mar 2005 20:09:03 +0000
Message-ID: <1111522143.7726.48.camel@localhost.localdomain> (raw)
In-Reply-To: <33c6269f05032211366ce4563b@mail.gmail.com>
References: <33c6269f05032206565ca4f9f1@mail.gmail.com>
<42404663.2010504@commandprompt.com>
<33c6269f05032211366ce4563b@mail.gmail.com>
On Tue, 2005-03-22 at 14:36 -0500, Alex Turner wrote:
> I will use an index 220-300, but not 200-300.
> ...
> Seq Scan on propmain (cost=0.00..15517.56 rows=6842 width=4) (actual
> time=0.039..239.760 rows=6847 loops=1)
> ...
> Index Scan using propmain_listprice_i on propmain
> (cost=0.00..22395.95 rows=6842 width=4) (actual time=0.084..25.751
> rows=6847 loops=1)
the rows estimates are accurate, so it is not a question of statistics
anymore.
first make sure effective_cache_size is correctly set, and then
if that is not enough, you might try to lower random_page_cost a bit
gnari
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: gnari@simnet.is, armtuk@gmail.com, jd@commandprompt.com
Subject: Re: Planner issue
In-Reply-To: <1111522143.7726.48.camel@localhost.localdomain>
* 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