pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (6+ messages)  latest in thread

Message-ID: <1111522143.7726.48.camel@localhost.localdomain>
Permalink:  ../1111522143.7726.48.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1111522143.7726.48.camel@localhost.localdomain

 · 

reply

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