Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Why the 8.1 plan is worst than 7.4?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "wmiro(at)ig(dot)com(dot)br" <wmiro(at)ig(dot)com(dot)br>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Why the 8.1 plan is worst than 7.4?
- Date: Tue, 30 May 2006 23:20:46 -0400
"wmiro(at)ig(dot)com(dot)br" <wmiro(at)ig(dot)com(dot)br> writes: > Why the plan is worst in postgres 8.1? (1) you have not actually shown us that the plan is worse. If you are complaining that the planner is wrong, EXPLAIN output (which contains only the planner's estimates) is useless for proving your point. Show EXPLAIN ANALYZE. (2) Have you ANALYZEd these tables recently in either database? The discrepancies in estimated rowcounts suggest that the two planners are working with different statistics. regards, tom lane
- References:
- Why the 8.1 plan is worst than 7.4?
- From: wmiro
- Why the 8.1 plan is worst than 7.4?
- Prev by Date: Re: Query performance
- Next by Date: Re: App very unresponsive while performing simple update
- Previous by thread: Re: Why the 8.1 plan is worst than 7.4?
- Next by thread: Bulk loading/merging
- Indexes: