Re: query planner not using the correct index - Mailing list pgsql-performance

From Craig Ringer
Subject Re: query planner not using the correct index
Date
Msg-id 489A623A.4090400@postnewspapers.com.au
Whole thread Raw
In response to query planner not using the correct index  ("Joshua Shanks" <jjshanks@gmail.com>)
Responses Re: query planner not using the correct index
List pgsql-performance
Joshua Shanks wrote:
> This query is run on a test system just after a backup of the database
> has been restored and it does exactly what I expect it to do

[snip]

Obvious questions:

- Have you changed the random page cost on either installation?

- Have both installations had VACUUM ANALYZE run recently?

- Are the stats targets the same on both installations?

- Do both installations have similar shared buffers, total available
  RAM info, etc?

--
Craig Ringer

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Plz Heeeelp! performance settings
Next
From: "Joshua Shanks"
Date:
Subject: Re: query planner not using the correct index