On Wed, Mar 8, 2017 at 3:32 PM, Patrick B wrote:
> Why is SEQ SCAN faster than index scan?
>
Same number of evaluated record and less effort-per-record​. You only win
with an index if you can evaluate fewer records to make up for the extra
effort per record that querying an index involves compa
Hi all.
I'm testing GIN indexes on a wildcard search.
Basically I've created this on my test environment:
create table test_gin_index (
> name_first CHARACTER VARYING(80) DEFAULT ''::CHARACTER VARYING,
> name_last CHARACTER VARYING(80) DEFAULT ''::CHARACTER VARYING
> );
insert into test_gin_ind
