Maxim Boguk <mboguk@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general