Re: [GENERAL] create index on a field of udt

[John R Pierce]

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