Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Why the difference in plans ??
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Why the difference in plans ??
- Date: Fri, 15 Sep 2006 10:08:35 -0400
- Message-id: <24190(dot)1158329315(at)sss(dot)pgh(dot)pa(dot)us>
"Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl> writes: > Why the difference and can I influence the result so that the first > query plan (which is the fastest) is actually used in both cases (I > would expect that the limit would be done after the sort?)? It likes the second plan because 6694025.41/353 < 41812.78. It would probably be right, too, if the number of matching rows were indeed 353, but it seems there are only 7. Try increasing your statistics target and re-analyzing. regards, tom lane
- Follow-Ups:
- Re: Why the difference in plans ??
- From: Joost Kraaijeveld
- Re: Why the difference in plans ??
- References:
- Why the difference in plans ??
- From: Joost Kraaijeveld
- Why the difference in plans ??
- Prev by Date: Re: RAID 0 not as fast as expected
- Next by Date: Optimize SQL
- Previous by thread: Why the difference in plans ??
- Next by thread: Re: Why the difference in plans ??
- Indexes: