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