Re: create index on a field of udt

[John R Pierce <pierce@xxxxxxxxxxxx>]

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