Re: index scan cost

From: "Dennis Brakhane" <brakhane(at)googlemail(dot)com>
To: "Jeff Frost" <jeff(at)frostconsultingllc(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: index scan cost
Date: 2008-07-17 22:58:23
Message-ID: 226a19190807171558m6450d110p5a9b05587861f90d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Frost 2008-07-17 23:12:44 Re: index scan cost
Previous Message Jeff Frost 2008-07-17 21:21:09 index scan cost