Re: [BUGS] BUG #5885: Strange rows estimation for left join

2011-02-16 Thread Maxim Boguk
On Wed, Feb 16, 2011 at 6:18 AM, Tom Lane wrote: > Maxim Boguk writes: > > Test case look like: > > > create table "references" ( attr_id integer, reference integer, > > object_id integer ); > > insert into "references" select *100**(random()), > > *10**(random()^*10*), *100**(random())

Re: [BUGS] BUG #5885: Strange rows estimation for left join

2011-02-15 Thread Tom Lane
Maxim Boguk writes: > Test case look like: > create table "references" ( attr_id integer, reference integer, > object_id integer ); > insert into "references" select *100**(random()), > *10**(random()^*10*), *100**(random()) from > generate_series(*1*,*1000*); > create index xif01refe

Re: [BUGS] BUG #5885: Strange rows estimation for left join

2011-02-15 Thread Maxim Boguk
Hi. Test case look like: create table "references" ( attr_id integer, reference integer, object_id integer ); insert into "references" select *100**(random()), *10**(random()^*10*), *100**(random()) from generate_series(*1*,*1000*); create index xif01references on "references" ( refer

Re: [BUGS] BUG #5885: Strange rows estimation for left join

2011-02-14 Thread Tom Lane
"Maxim Boguk" writes: > I found that strange effect while helping with slow query on russian > postgresql online forum. Please try to put together a self-contained test case for this. I could not reproduce such a weird result here, but that probably just means there's something strange about your