On 6/28/2015 11:24 PM, Shujie Shang wrote:
> insert into test values (generate_series(1, 3000000), (1, 'hi')::info);
> explain select * from test where i.id <http://i.id>=1;
> the result is : seqscan
does not every row of that match i.id = 1 ?
try ...
insert into test values (generate_series(1, 3000000),
(generate_series(1, 3000000), 'hi')::info);
analyze test;
explain select * from test where getID(i) <http://i.id>= 1;
--
john r pierce, recycling bits in santa cruz