[PERFORM] Why query plan is different?

2016-10-10 Thread Andrzej Zawadzki
Hi, Today, I noticed strange situation: The same query run on different servers has very different plan: Q: SELECT b.* FROM kredytob b  WHERE pesel = '222'  ORDER BY b.id DESC LIMIT 1 Slow plan: "Limit  (cost=0.43..28712.33 rows=1 widt

Re: [PERFORM] Why query plan is different?

2016-10-10 Thread Pavel Stehule
2016-10-10 17:31 GMT+02:00 Andrzej Zawadzki : > Hi, > Today, I noticed strange situation: > > The same query run on different servers has very different plan: > > Q: SELECT b.* FROM kredytob b WHERE pesel = '222' ORDER BY b.id > DESC LIMIT 1 > > Slow plan: > > "Limit (cost=0.43..28712.3

Re: [PERFORM] Why query plan is different?

2016-10-10 Thread Andrzej Zawadzki
On 10.10.2016 19:09, Pavel Stehule wrote: 2016-10-10 17:31 GMT+02:00 Andrzej Zawadzki : Hi, Today, I noticed strange situation: The same query

Re: [PERFORM] Why query plan is different?

2016-10-10 Thread Andrzej Zawadzki
On 10.10.2016 17:31, Andrzej Zawadzki wrote: Hi, Today, I noticed strange situation: The same query run on different servers has very different plan: Q: SELECT b.* FROM kredytob b  WHERE pesel = '222'  ORDER BY b.

Re: [PERFORM] Why query plan is different?

2016-10-10 Thread Pavel Stehule
2016-10-10 23:17 GMT+02:00 Andrzej Zawadzki : > On 10.10.2016 17:31, Andrzej Zawadzki wrote: > > Hi, > Today, I noticed strange situation: > > The same query run on different servers has very different plan: > > Q: SELECT b.* FROM kredytob b WHERE pesel = '222' ORDER BY b.id > DESC LIMIT