The "fast" server makes a much more accurate estimation of the number
of rows to expect (4 rows are returning, 1 was estimated). The "slow"
server estimates 1151 rows. Try running ANALYZE on the slow one
Next:From: Jeff FrostDate: 2008-07-17 23:12:44
Subject: Re: index scan cost
Previous:From: Jeff FrostDate: 2008-07-17 21:21:09
Subject: index scan cost