Postgres Pro
Downloads
Home   >   mailing lists

Re: index scan cost - Mailing list pgsql-performance

From Dennis Brakhane
Subject Re: index scan cost
Date
Msg-id 226a19190807171558m6450d110p5a9b05587861f90d@mail.gmail.com
Whole thread Raw
In response to index scan cost  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Jeff Frost
Date:
Subject: Re: index scan cost
Next
From: Tom Lane
Date:
Subject: Re: index scan cost