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())
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
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
"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