Re: Postgresql selecting strange index for simple query - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgresql selecting strange index for simple query
Date
Msg-id 6815.1235683837@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql selecting strange index for simple query  (Maxim Boguk <mboguk@masterhost.ru>)
List pgsql-general
Maxim Boguk <mboguk@masterhost.ru> writes:
> I try simplify test case and:
> Now use sequential user_id, and truncate last_change_time to date:

> SELECT nextval('test_seq') as user_id,last_change_time::date ,rpad('a',500,'b') as f1 into test_table from resume;

Could you send me a dump of this test_table off-list?  It seems like
there must be something strange about the stats of last_change_time,
but I don't feel like guessing about what it is ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: speaking of 8.4...
Next
From: "Joshua D. Drake"
Date:
Subject: Re: speaking of 8.4...