Thursday, July 17, 2008

Re: [PERFORM] index scan cost

On Fri, 18 Jul 2008, Dennis Brakhane wrote:

> 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

You're quite right. I probably didn't mention that the slow one has been
analyzed several times. In fact, every time adjusted the statistics target
for that column I analyzed, thus the eventually better, but still inaccurate
estimates toward the bottom of the post.

--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

No comments: