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=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)
= 1;
--
john r pierce, recycling bits in santa cruz